Thanks, that does work; however, the database is only picking up 5\11 records. Also, as in other database using, when I click to open a report, a pop up box start date and end date have to be entered. This includes when opening the query. I'm okay with the pop up not appearing, but would like...