Access Reports

J

JamieM

I would like to show the parameters (Beginning Date and Ending Date) from a
"Date Received" field on the Report in Access either in the Footer or Header.
Is this possible?
 
J

Jeff Boyce

Jamie

A typical way to handle this is to use a form to "collect" the parameters.
Your query then refers to the form for the criteria. Your report then
refers to the form for the values to display.
 
F

fredg

I would like to show the parameters (Beginning Date and Ending Date) from a
"Date Received" field on the Report in Access either in the Footer or Header.
Is this possible?
Click to expand...

Add an unbound 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.
 
J

JamieM

thanks! That helped.

fredg said:
I would like to show the parameters (Beginning Date and Ending Date) from a
"Date Received" field on the Report in Access either in the Footer or Header.
Is this possible?
Click to expand...

Add an unbound 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.
Click to expand...
 
Top