Parameter Query In Report Title

  • Thread starter Thread starter Diana Robinson
  • Start date Start date
D

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
 
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
 
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.
Click to expand...
Thank you- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

John it worked perfectly. Thank yuo so much!
 
Back
Top