Parm in Report Header

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

The query that runs my report has a parm for a date
field -- in 'criteria' row, Between [enter a beginning
date] and [enter an ending date].

This does give me all of the dates between my desired
range.

I would like to be able to have these 2 dates appear in
my report header.

I do not know SQL but hope you can help.

thank you.. Susan
 
susan said:
The query that runs my report has a parm for a date
field -- in 'criteria' row, Between [enter a beginning
date] and [enter an ending date].

This does give me all of the dates between my desired
range.

I would like to be able to have these 2 dates appear in
my report header.

I do not know SQL but hope you can help.
Click to expand...


Fortunately, reports have a nice feature that allow you to
refer to a query parameter as if it were a field in the
qiery. This means you can just use the parameter prompt in
a text box expression:

="For dates from " & [enter a beginning date] & " to " &
[enter an ending date]

Just make sure you spell the prompt strings **exactly** the
same as in the query.
 
Thank you !! It worked great.
-----Original Message-----
susan said:
The query that runs my report has a parm for a date
field -- in 'criteria' row, Between [enter a beginning
date] and [enter an ending date].

This does give me all of the dates between my desired
range.

I would like to be able to have these 2 dates appear in
my report header.

I do not know SQL but hope you can help.
Click to expand...


Fortunately, reports have a nice feature that allow you to
refer to a query parameter as if it were a field in the
qiery. This means you can just use the parameter prompt in
a text box expression:

="For dates from " & [enter a beginning date] & " to " &
[enter an ending date]

Just make sure you spell the prompt strings **exactly** the
same as in the query.
Click to expand...
 
Back
Top