criteria different in 2 fields

[Guest]

I have a course database where the table contains term, subject, courseno. I
need the query criteria to be subject = ENG or FLR and courseno <500. But I
also need subject to be WR and courseno >123. Is there a way I can do this?

 

[Guest]

Try

Select * From TableName
Where
(subject In ("ENG" ,"FLR") And courseno <500) Or
(subject = "WR" And courseno >123)

 

[Guest]

That didn't work because it needs to be AND subject = WR and Courseno >123,
but you gave me an idea about creating a union query.
Thanks