I have a data table that contains an open date and close date for each entry. I've been asked to create a report that does the following 3 things: allows a date range for when items are opened (easy enough based off the open date) allows a date range for when items are closed(also easy because of the between  and ) now the real issue I'm having is this third item. Based off of whatever open range picked in Item #1 I need to generate a list of issues opened prior to whichever start date is chosen and out of those issues I need to show only the ones that stayed open past the end date of the range. I've gone around this a few different ways and I can't get it to work. I've tried to do this as seperate quieries (the open date query and close date query have been easy) I can't get this third one to work though. I just want to be able to have a query that looks at the date range I put in, gives me the cases opened before the start of my selected date and still open at the end of my selected range. I also need to turn this all into a report (hopefully in one report) Can everything be done in 1 query?