criteria different in 2 fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try

Select * From TableName
Where
(subject In ("ENG" ,"FLR") And courseno <500) Or
(subject = "WR" And courseno >123)
 
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
 
Back
Top