Parameter Query In Report Title


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
 
Ad

Advertisements

J

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
 
D

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!
 
Ad

Advertisements

A

ameliadent

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top