Query Parameters Printed on Report

[AngelT]

I have reports based on queries, which in turn have parameters (beginning/ending dates) being requested by user.

I need to print this date range on the report header.

How do I go about this?

 

[RobJ]

how do users select these parameters?
if selected on a form, you can make a field on your report with expression:

=[form]![frmName]![frmField]

RobJ

 

[Graham T]

How to Print Parameters onto your report:

If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and specify the parameter by name as the control's Control Source using the form

=Reports![reportname]![parametername]

Let's suppose you want to add the feature to a report named rptHolidayRequests and your query's parameter is Between [Enter Start Date] And [Enter End Date]. In this case, you'd enter the expressions of

=Reports![rptHolidayRequests]![Enter Start Date]

=Reports![rptHolidayRequests]![Enter End Date]

HTH

Graham

 

[AngelT]

Yes, I am receiving the parameters via a query.

I attempted your way Graham, and I must be missing something cuz' when I did as you suggested I did not get anything.

Thank you both for your assistance in this matter.

 

[AngelT]

I'M GETTING CLOSER!!!

Okay......now are you saying by entering in this parameter as the reports text box control source that I do NOT need to also include the parameters within the query the report is based off of?

Because now I am getting prompted TWICE to enter the date (once from report, once from query).

 

[AngelT]

I GOT IT!!!!

THANKS SOOOOO MUCH!!