Hi folks....I have been checking out this group and have found help
and solutions to everything I have needed up to this point. I have
created a report based on a Query to show me certain activity during a
specific period. When I run the report a prompt asks me for the start
date and end date of the period. How can I have the report show those
same dates without retyping them?
Thanks,
On Mon, 19 Nov 2007 11:21:39 -0800 (PST), NicholasSerpentine@gmail.com
wrote:
> Hi folks....I have been checking out this group and have found help
> and solutions to everything I have needed up to this point. I have
> created a report based on a Query to show me certain activity during a
> specific period. When I run the report a prompt asks me for the start
> date and end date of the period. How can I have the report show those
> same dates without retyping them?
>
> Thanks,
Add an unbound control in the Report Header.
Set it's control source to something like:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]
The text within the brackets must be identical to the bracketed text
in the query.
You may wish to format the dates, in which case:
="For sales between " & Format([Enter Start Date],"mmmm d, yyyy") & "
and " & Format([Enter End Date],"mmmm d, yyyy")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
The article explains 2 ways to do this. Both include details of how to show
the date range on the report.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
news:ce8030a4-8807-4200-b8b1-88f25c6750e9@i37g2000hsd.google groups.com...
> Hi folks....I have been checking out this group and have found help
> and solutions to everything I have needed up to this point. I have
> created a report based on a Query to show me certain activity during a
> specific period. When I run the report a prompt asks me for the start
> date and end date of the period. How can I have the report show those
> same dates without retyping them?
>
> Thanks,