Help

[jaybarnard]

I am not an expert user of Access and need some help, i have created areport but i want to be able to enter a criteria of a start date and end date for the report contents. I have been driving my self mad trying all sort of ways to do this can anybody point me in the right direction.

 

[ColinEssex]

In the query running the report, in the date field criteria put this

 Between [Enter start date] and [Enter end date]

Col

 

[jaybarnard]

Thanks for that

 

[tmarsh]

In the query running the report, in the date field criteria put this

 Between [Enter start date] and [Enter end date]

Col

If you put a couple of text boxes in your report header you can show dates retrieved. I use

=Min([START_DATE])

in the control source and Max for the other.

Possibly there's a better way but it works OK.