Show prompted Query criteria on report

[NicholasSerpentine]

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,

[fredg]

On Mon, 19 Nov 2007 11:21:39 -0800 (PST), Ni****************@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

[Allen Browne]

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.

<Ni****************@gmail.comwrote in message
news:ce**********************************@i37g2000 hsd.googlegroups.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,