Query Criteria problem.

[Monti2]

I am trying to run a query as folllows:

I have a field in a table with 100 records called Colour, which contains 10 different colours.

I am trying to set the criteria so the results contain all records except where the colour is "Black" or "White".

I can achieve this by listing the 8 colours that I require in the results, however I would like to know how to achieve this using NOT and just Black, White.

I would also like to know how to code this using SQL.

I appreciate any help.

Thanks

 

[Mile-O]

SELECT tblColours.Colours
FROM tblColours
WHERE (((tblColours.Colours)<>"White" And (tblColours.Colours)<>"Black"));

 

[neileg]

Or, in query design view enter <> "white" and <> "black" in the criteria rows for colour.

Sames as Mile-o-phile, just easier if you don't use the SQL view often.

 

[Monti2]

Got it working now.

Thanks for your help.