Putting Criteria in report

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

Guest

I have a report built off a query. When the query and report are ran, it
asks the user for a beginning and ending date and the records show up that
are between those 2 dates. Is there a way I can put the beginning and ending
dates that are entered into the report or page header on the report. So,
when the report show's up, at the top it will say what dates the records are
coming back for?
 
I have a report built off a query. When the query and report are ran, it
asks the user for a beginning and ending date and the records show up that
are between those 2 dates. Is there a way I can put the beginning and ending
dates that are entered into the report or page header on the report. So,
when the report show's up, at the top it will say what dates the records are
coming back for?
Click to expand...

Add an unbound text control to the Report Header.
Set it's control source to:

="For Sales between " & [Beginning Date] & " and " & [Ending Date]

The text within the brackets MUST be identical to the bracketed
parameter text in the query.
 
You should consider allowing your users to enter all criteria through
controls on forms. Parameter prompts are not nice.

However, you can add a text box to your report and set its control source to
something like:
="Report for dates " & [Beginning Date] & " and " & [Ending Date]
 
Back
Top