Oldest and Most Recent dates in header

  • Thread starter Thread starter MCH
  • Start date Start date
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
 
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
 
Back
Top