date range

[sthapa]

Hi, I have a standard database and wanted to run a report based on a date range in a particular field. What I wanted to do is to link a report to the form via a command button. The only thing is before this report actually executes i want to have the option of inserting a date range.

Any ideas ?

 

[ColinEssex]

In the date criteria of the query put this

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

That way you'll get a prompt to enter the dates.


Col

 

[sthapa]

Thanks

In the date criteria of the query put this

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

That way you'll get a prompt to enter the dates.


Col

Thanks for that

 

[AN60]

sthapa

If you want to "go up market" you could place calendar controls on a form to select a start date & end date for your report(s). Search around for Calendars, in particular Mile-O-Phile's version which is somewhere on this board. M-O-P's is a good one to get going if you haven't done it before.