Best way to find the Most Recent Records

[dmon000]

Hi,
I have two linked table, Patients and Diet Orders. In Diet orders there is a field which identifies each diet order as breakfast, lunch or dinner. Also in Diet Orders is a date fieled and a time field. For each patient and meal there may be more than one record with different times. What would a query look like that would select the just the latest records for all the patients?

Thanks

 

[PHV]

a date fieled and a time field
Why TWO fields for a SINGLE DateTime value ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886