View Query Parameters on a report

Hi,

I have created a report based on a query.

To get the sums I need for the report my query contains
parameters for the date ie Between [Start Date] And [End
Date]

It also contains a Where in the Totals area of the date
field to enable me to get totals of another field for a
user specified date range.

This works well and I get the report I need. But I would
like to show the date range the user has requested on the
report. Can I put a textbox on the report that will enable
this and if so what do I put in the textbox to get the
parameters to fill in automatically.

To date I have managed to get the date on there only in a
way which requires the user to enter the date parameters
twice, which long-term will be too frustrating.

Any ideas on this?

Cheers,

Sue

Yes, simply put an unbound text box with the following in it...

= "Between " & [Start Date] & " and " & [End Date]


Hope that helps,

Rick


"SueM" wrote in message
...
Hi,

I have created a report based on a query.

To get the sums I need for the report my query contains
parameters for the date ie Between [Start Date] And [End
Date]

It also contains a Where in the Totals area of the date
field to enable me to get totals of another field for a
user specified date range.

This works well and I get the report I need. But I would
like to show the date range the user has requested on the
report. Can I put a textbox on the report that will enable
this and if so what do I put in the textbox to get the
parameters to fill in automatically.

To date I have managed to get the date on there only in a
way which requires the user to enter the date parameters
twice, which long-term will be too frustrating.

Any ideas on this?

Cheers,

Sue

Brilliant... so simple when you know how!
-----Original Message-----
Yes, simply put an unbound text box with the following in
it...

= "Between " & [Start Date] & " and " & [End Date]


Hope that helps,

Rick


"SueM" wrote in
message
...
Hi,

I have created a report based on a query.

To get the sums I need for the report my query contains
parameters for the date ie Between [Start Date] And [End
Date]

It also contains a Where in the Totals area of the date
field to enable me to get totals of another field for a
user specified date range.

This works well and I get the report I need. But I would
like to show the date range the user has requested on
the
report. Can I put a textbox on the report that will
enable
this and if so what do I put in the textbox to get the
parameters to fill in automatically.

To date I have managed to get the date on there only in
a
way which requires the user to enter the date parameters
twice, which long-term will be too frustrating.

Any ideas on this?

Cheers,

Sue


.