I have a report based on a single table, one column is for the date. I want to be able to open the report based on date. If I add a criteria which asked for the date the report opens with all the data for that date, I tried to add an end date but when I run the query no data is returned. I used: [Start Date]And[End Date]
Paul

forget Between
in a criteria type:
Between [Start Date] And [End Date]
I hope it will help

Thank for the quick response it worked great