Reports, queries and Parameters...

  • Thread starter Thread starter clamfuddle
  • Start date Start date
C

clamfuddle

I am designing a sales report that is based on a query.

Part of the query is the sale date, which the user is
able to enter as a parameter.

How do I capture that parameter value and print in on
each page of the report?

Thanks!

Bryan

(I'm good with tables, and queries, but normally don't ever
have to build forms and reports....)
 
I am designing a sales report that is based on a query.

Part of the query is the sale date, which the user is
able to enter as a parameter.

How do I capture that parameter value and print in on
each page of the report?

Thanks!

Bryan

(I'm good with tables, and queries, but normally don't ever
have to build forms and reports....)
Click to expand...

On each page of the report?
Add an unbound control to the page header.
Set it's control source to:
= "For sales on " & [Enter Date]

The text within the brackets must be identical to the query parameter
text within the brackets.
 
Back
Top