Passing dates from pop up boxes to report

Stacey

Registered User.
Local time
Today, 14:47
Joined
Sep 10, 2002
Messages
84
I have a report based on a query. The query criteria of Between [Start Date] and [End Date] in the DateReceived field. I had this report built in Access 2000. In an unbound text box on the report I had : =[Start Date] &" to" & [End Date]. It worked fine when it was in Access 2000 but since we converted to Access 2003, it no longer works. Does it have to be done a different way now?
 
Try:

=forms!formName![Start Date] &" to" & forms!formName![End Date]

assuming the field names on your pop-up form are StartDate and EndDate
accordingly.

Also, make sure that your popup form is open while running the report.
 

Users who are viewing this thread

Back
Top Bottom