Faulty filtering

[kupe]

A field has different occupations. I DON'T want these jobs to turn up:

SELECT *
FROM qryMain
WHERE (((qryMain.Work)<>'Available' Or (qryMain.Work)='Dismissed' Or (qryMain.Work)='Induction' Or (qryMain.Work)='Open University' Or (qryMain.Work)='Restricted' Or (qryMain.Work)='Seg*' Or (qryMain.Work)='Unemployed') Or (qryMain.Work)='Education*');

It seemed to be working fine last night on a different computer. This morning it doesn't filter out anything. Can anyone spot the (obviously) glaring fault please?

 

[kupe]

That's very good of you, Pat, to explain it so thoroughly. It is appreciated very much. And thanks too for the examples. Gratefully paul