Access 2003 - Report Page header date fields
Posted on 2011-10-03
I have a report based on a query. The query has 3 prompts, Start Date, End Date, Student Name. The query works fine. The report also works fine...until I try to add the Start and End dates the user entered into the report header. The query uses [Start Date], [End Date]. When I add a label at the top of the report that says TO: and a field that says [Start Date] and FROM: and a field that says [END DATE], when I run the report I now get prompted TWICE for the start and end dates. The report displays the correct data, and it has the correct dates at the top, but I don't want to be prompted twice for the dates. If I remove the two fields [Start Date] / [End Date] from the report header, it works fine. How do I reference these user enetred dates in the header and not get prompted twice.