Query stops working when I add criteria to one of two date fields

[AdiDoyle]

I'd appreciate any help I could get on this one, it has me scratching my head. I'm not entirely new to access or SQL but I don't have a huge amount of experience.


I have a table (appointments) that contains two different date fields. ApptDate_1 is for one type of appointment, ApptDate_2 is for a different type of appointment.



I have a query to gather data to put into a report. Both ApptDate1 and ApptDate2 are required to be displayed in different areas of this report, so the query looks for both. There is no problem with the query until I try to set criteria for ApptDate1 or ApptDate2.

I want to set the criteria >=Date() on both date types, so that I only see future appointment dates, however, when I set this on either ApptDate1 or ApptDate2, the query only returns appointments of that date type. When I set it on both date types, the query doesn't return any results at all.


Can anybody please tell me why this is happening? Or how to get around this problem?

[Bob Fitz]

Put the criteria for each date on a different row in the designer so that the criteria date1 or date2 rather than date1 and date2

[AdiDoyle]

Hey, of course. That worked perfectly. I don't know why I was being such a muppet, but I thought doing that would still show appointments that occurred before the current date.

Thanks a million.