Prompting for specific dates

[vand_uk]

Hi all
Im wanting to open a sales report, but I want to be prompted to enter dates FROM and TO so that I can get specific sales.

Example

"Enter start date" here i'd enter 1/8/05
"Enter end date" here i'd enter 31/8/05

that way i'd get all sales throughtout august. Then when september comes round I could enter new dates and save me having to go in and change the filter.

Can anyone help?

Thanks

 

[ColinEssex]

In the query criteria line for the date field put this

Between [Enter Start Date] and [Enter End Date]

Col

 

[vand_uk]

thank you

i always seem to get stuck on the simple things!!

thanks again

 

[Rich]

You might like to refine it further and pass the query parameters via a form where you can validate the dates; you might also add a calendar control to make it virtually foolproof.
Examples of both methods have been posted here