Access Reports

[Guest]

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?

 

[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.

 

[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?

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.

 

[Guest]

thanks! That helped.

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?

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.