DLookUp Question

[DeutchBose]

I have a query that results in two identicdal records, with the only difference being a date/time field.

Can I, with the DLookup Function, extract the record with the most recent date? or pehaps the least recent date?

i.e.:

DLookup("Field1", "Table1", {Lowest Date Value})

 

[Norie]

Can you use a totals query and select Max or Min against the date?