Run a report in between 2 dates

[cretam]

I would like to add 2 calendars so you can select a date from and a date to so the report will only display the records in the between the dates. Is this possible? How would I go about it?

 

[Kiwiman]

Howzit

Create a form that you will run your report from. Have a minimum of 3 controls:

1. 2 x text boxes
2. 1 x command button - to run the report

Have two text boxes intially for your from date and your to date - enter the dates manually first to get the report working.

For use of a calendar to enter the date fields search for Uncle Gizmos calandar form. There are no doubt others to use as well that will do the same thing - but I use this and it is easy to implement.

In the query underlying the report reference your date field to your text boxes on your form - something like

Between [Forms]![yourform]![yourfromcontrol] And [Forms]![yourform]![yourtocontrol]

See Uncle Gismos link in his first post

[URL="http://www.access-programmers.co.uk/forums/showthread.php?t=148750"]http://www.access-programmers.co.uk/forums/showthread.php?t=148750[/URL]