Unanswered: Display 1st and Last Record Date in Report
I have been browsing through the forum and all of the questions pertaining to displaying a date range at the top of a report involve a user defined date range within access (via a form or other input method).
The data table I have is generated from software outside of Access, and the dates are defined within that piece of software.
What I'm looking for is a way for the report heading to display the oldest and newest date out of all the records in that table. Any ideas?
Where DateColumn is the name of the column where the date is stored, TableName is the name of the table and OptionalCondition can be a condition to filter the contents of the table (e.g. "DateColumn > #01/15/2010#" or "RecordID < 1000", or "Name Like 'P*'").