|
| 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
September 24th, 2008, 07:22 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
September 24th, 2008, 08:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
September 24th, 2008, 09:29 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
