query to set criteria of latest date

R

r subrahmanian

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.
 
K

Klatuu

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")
 
Top