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

On 6/8/2011 9:00 AM, Diana Robinson wrote:
> 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
>

On Jun 8, 12:25*pm, John Spencer <JSPEN...@Hilltop.umbc> wrote:
> 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
>
> On 6/8/2011 9:00 AM, Diana Robinson wrote:
>
>
>
> > 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!