query to set criteria of latest date

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

Guest

I have a table with a date column (generally but not always weekly
intervals), and other values. I want to create a query that will return the
values for the latest date.
 
Put this in the Criteria row of your date field column. Change the named to
your date field name and your table name. It will return only records that
match the most recent date in your table.

DMax("[MyDateFieldName]","MyTableName")
 
Back
Top