User's date needs to coorespond to other info when printed w/ a report

[incognito]

I need to be able to enter a date and have the cooresponding information come up into the reports so i can print it. Any ideas?

 

[jimmythegeek]

The most basic way, is to create a query with everything you need. In the criteria row of the date field of your choice, put this:

=[Enter Date] OR
Between [Start Date] AND [End Date]

Now build your report based on this query, and when you run it, it will ask you for the date(s). Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[Quehay]

Do you want to incorporate the parameter response into the report title? This is really easy: Just include the "[Enter the parameter]" statement in the control source of a textbox on the report.

[tt]ControlSource = "Report shows data from " & [Enter the beginning date]& " to " & [Enter end date][/tt]

This comes from a Help section Title: "Print the criteria for a report in the report header" (Sometimes it's so blasted difficult to find the right Help section with searches).