View Query Parameters on a report

  • Thread starter Thread starter SueM
  • Start date Start date
S

SueM

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


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
Click to expand...


.
Click to expand...
 
Back
Top