latest record using date time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table that has records added 3 times a day with one field that has date/time. How would I set up a query filter to look for the last record by date/time.

Thanks Tom
 
Tom,

Make a select query, and in the criteria line below the date/time field use
a DMax epression, something like:
=DMax("[DateTimeField]","TableName")
substituting DateTimeField with the actual field name and TableName with the
actual field name.

HTH,
Nikos

Tom Wormsley said:
Hello,

I have a table that has records added 3 times a day with one field that
Click to expand...
has date/time. How would I set up a query filter to look for the last record
by date/time.
 
Back
Top