If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display query parameters on report | Little pete | Setting Up & Running Reports | 4 | October 1st, 2004 02:01 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |
Crosstab query in report | Vincent DeLuca | Setting Up & Running Reports | 19 | July 13th, 2004 04:02 AM |
Query Form: Print Report | Dennis | Running & Setting Up Queries | 1 | June 6th, 2004 01:08 PM |