I am creating a Access query to pull a date from 4 different fields (Date1, Date 2, Date 3, Date 4) in the same record. An example of the criteria that I am trying to extract is asking for a specific date for one report and a range of dates for a second report. My problem is that a July date (unwanted date) is showing up and it shouldn’t. Also the in the monthly report that I’m asking for a date range of 8/1/11 – 8/31/11, it is showing some unwanted dates from other months that is not what my criteria was asking for. An example of my problem is: Date 1 shows up with a July 2011 date, Date 2, Date 3 and Date 4 shows a date in August like I specified in the criteria. The problem is that I don’t want this July date or any other unwanted date showing up and calculating in my report. I just want what I asked for. What am I asking for incorrectly? And how do I extract just what I need? I was using a parameter in my query, is this where I am going wrong? Please help! I am late on providing these reports to a supervisor and I just can’t figure out the problem. Thank you in advance.