:banghead: I am using Access 2007. I have a table dealing with vacations with FirstName, LastName, BeginDate and, EndDate. I would like to be able to run a report via a Report Date Range form which will allow me to check who all are on vacation between the BeginDate and the EndDate. I would be very grateful for any help that anyone could give please. what would be even better is a downloadable sample database. Many thanks in anticipation.