Capture selected criteria on reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some reports which are based on a date criteria that is entered in a
message box. I want the entered dates to be capture unto the report that
comes up based on the date.

Can someone help please.
 
I have some reports which are based on a date criteria that is entered in a
message box. I want the entered dates to be capture unto the report that
comes up based on the date.

Can someone help please.
Click to expand...

Add an unbound control to the report header.
Set it's control source to something like this:
= "Sales between " & [Start Date] & " and " & [End Date]

The bracketed text above must be identical to the bracketed text in
the query.
 
Back
Top