Parameter Query In Report Title

[Diana Robinson]

I have a report that is based on a parameter query. The query is as
follows: Between [Beginning Date] And [Ending Date]. I would like to
have the parameters of the query appear in the report header once it
has been run. I have tried placing a text box in the header and placed
the query in the record source but it will not work. Any suggestions
would be greatly appreciated.

Thank you

 

[John Spencer]

Add a textbox control to your report
set its control source to
= "Between " & [Beginning Date] & " and " & [Ending Date]

Parameter prompts can be referred to as if they were fields in the query. Be
sure you spell the prompts exactly as they are in the query.

If you want to format the dates to something other than the default, you can
use the format function
= "Between " & Format([Beginning Date],"mmmm d, yyyy") & " and " &
Format([Ending Date],"mmmm d, yyyy")




John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Diana Robinson]

Add a textbox control to your report
set its control source to
= "Between " & [Beginning Date] & " and " & [Ending Date]

Parameter prompts can be referred to as if they were fields in the query. Be
sure you spell the prompts exactly as they are in the query.

If you want to format the dates to something other than the default, you can
use the format function
= "Between " & Format([Beginning Date],"mmmm d, yyyy") & " and " &
Format([Ending Date],"mmmm d, yyyy")

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

I have a report that is based on a parameter query. The query is as
follows: Between [Beginning Date] And [Ending Date]. I would like to
have the parameters of the query appear in the report header once it
has been run. I have tried placing a text box in the header and placed
the query in the record source but it will not work. Any suggestions
would be greatly appreciated.

Thank you- Hide quoted text -

- Show quoted text -

John it worked perfectly. Thank yuo so much!

 

[ameliadent]

This is forcing me to enter my parameter dates twice, unfortunately. Any wisdom?