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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Date Field Null Values 3
Using the latest date in a table as criteria 4
maintenance job schedule creation re dates 0
Excel MS Excel - MS Office 2010 0
Show the date of the last time the query was run 8
Date Query 1
Divide a a range of dates into intervals starting with the current date or the latest date in the ra 2

Back
Top