Parameter Query and "OR"

[Student Databaser]

I am trying to get this query to show me all the courses that began during a
certain time period AND courses outside of that time period that are
designated as "ON GOING". It seems so simple but for some reason my query
only returns the courses between the parameters and excludes the second part.


Here is the SQL:
SELECT COURSE_OFFERINGS.COURSE_NAME, COURSE_OFFERINGS.BEGIN_DATE,
COURSE_OFFERINGS.DELIVERY_MODE
FROM COURSE_OFFERINGS
WHERE (((COURSE_OFFERINGS.BEGIN_DATE) Between [start date] And [end date]))
OR (((COURSE_OFFERINGS.DELIVERY_MODE)="ON GOING"));

 

[Douglas J. Steele]

Are you sure that the table includes the value ON GOING?

If, for instance, you used the Lookup Wizard, what displays when you look at
the table isn't what's actually stored in the table.

 

[Maarkr]

try breaking it down and leave out the first part and try to get the second
part working by itself...check spelling, spaces, or use ' like '...