I have an Access 2003 databas. When I run a report I want it to show the dates that I have chosen to run from the query.
In the query I had between [start date[ and [end date]
I put [start date] and [end date] in text boxes on the report and worked just fine.
I now am running a macro that creates a new table with critera from existing tables and then when that is fnished the report opens up. Is there a way I can get the dates I put in the first query criteria to create the new table that the report is based off of to show up on the report?