Oldest and Most Recent dates in header

M

MCH

I have a report that I need to modify so put the oldest and most recent dates
in the header. I want to look at a specific field and find the oldest date
in the report results and also the most recent date in the report results.

I don't know how to do this. Anyone?

thanks, Crockett
 
D

Darrell Childress

Crocket, if I'm understanding you correctly, you would use
Min([YourDateField])
Max([YourDateField])

If you want to put a statement in the header, use something like
="From " & Min([YourDateField]) & " to " & Max([YourDateField])
This will show the range of records shown
Darrell
 

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

Append Query with Oldest top Records by Group 1
Macro to filter on most current date. 5
Most recent date 2
Selecting oldest or newest data from multiple records 2
Pulling the oldest date from range of dates 4
Creating a Query that Deletes Duplicates by Date 8
accepting most recent date across columns 10
Access Compare records in same access table 0

Top