Date Criteria

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

What criteria would you use to pull up the latest date in a series of dates?
Thanks.
 
You should be able to use an aggregate function, and look
for the Max record in the field. Just hit the Sigma button
(looks like a weird E) to view the grouping, and select
Max to retrieve the maximum (most recent) date in that
field.

HTH,

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

Criteria help 4
criteria on form 1
Date Criteria Range 1
Query - pull past 12 months 1
Date/Time Selection problem!!!!! 10
Date parameter question 2
criteria for date field using iif() 1
Query for previous week, Sun thru Sat, from date field 1

Back
Top