find the last record

[Salin]

Hi,

I have an ApptTable with number of fields,

such as PtName, PtDOB, ApptDate and etc.

How can I find the last appointment date

that is > 1/1/2008, and each person is

50 and older in the ApptTable?

Appreciate for any help.

Salina

[mr_vodka]

If you are talking about the last appointment date for each patient, then you will need to have either a self join relationship based on patient ID or if the database is in a proper format where the patients are in a seperate table, then you can just create the calc there. Either or, the calc that has the lastest appointment would be Max ( SelfJoin::ApptDate ) or (PatienttoAppointmentTable::ApptDate) whichever setup you have...

Then the find would be >50 for the age >1/1/2008 for the new calc

[Salin]

Thanks John for your help. Max function should

work in my case as I have a main table and an

appt table. However, I only know how to use

Set Field and Perform Find to find a set of data.

Set Field doesn't seem to let me put in the max

function. I did some readings in FileMaker

scripting and tried different ways in my script.

There is still no luck to get my script to perform.

I guess I need some more handheld help. Would you

mind and give me an example of a simple script

with the max function?

Thank you very much!

Salina

[Fenton]

Are you trying to use the Max() function while you're in Find mode? Because it won't work then, no calculation that depends on data will, as the only data available in Find are globals, or variables. With FileMaker 8.5 you can use the latter. Set your Max() value into a script Variable, using the Set Variable step. Then use that to Set Field during the Find.