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
|
|||
|
|||
Displaying a date range in my report
I have a report run where I select the records based on the date a service
was performed. My query asks for a range with a start and end date on this field. How can I show this range on my report? -- Anne |
#2
|
|||
|
|||
Displaying a date range in my report
On Wed, 24 Sep 2008 11:22:01 -0700, Anne wrote:
I have a report run where I select the records based on the date a service was performed. My query asks for a range with a start and end date on this field. How can I show this range on my report? Exactly what are the query parameters? Let's say it is Between [Start Date] and [End Date] In the Report header, add an unbound text control. Set it's control source to something like: ="For sales between " & [Start Date] & " and " & [End Date] The text within the brackets must be identical to the bracketed text in the query. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Displaying a date range in my report
Thanks, just had to change the text to reflect my fields. It worked like a
charm. -- Anne "fredg" wrote: On Wed, 24 Sep 2008 11:22:01 -0700, Anne wrote: I have a report run where I select the records based on the date a service was performed. My query asks for a range with a start and end date on this field. How can I show this range on my report? Exactly what are the query parameters? Let's say it is Between [Start Date] and [End Date] In the Report header, add an unbound text control. Set it's control source to something like: ="For sales between " & [Start Date] & " and " & [End Date] The text within the brackets must be identical to the bracketed text in the query. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|