Problems calculating a fields data

[spurs100]

Hi all,

I have an appointments table with the following fields:

Patient ID || Appointment Date || Appointment Time || Appointment type || Last Appointment

I need the Last Appointment field to calculate when the patients last appointment was using the data in this table. How can i do this? Can anyone help?

 

[BanditWk]

Try using a DLookup or DMax function, as such:

=DLookup("[AppointmentDate]","NameOfTable","[PatientID] = 'CriteriaForPatientID'&quot
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)