A Query that "doesn't" select a value

[Donny]

I want to run a query that selects everything accept a value i place in the criteria. I know its basic, put it down to writers block. What is the SQL

 

[DJN]

Donny, Put the word Not in the criteria. e.g. Not Like "F.C." & "*" This will select all record except those with F.C. in the field.

 

[mymou]

For QBE can use:

<>
Is Not Null
=True

You can view the SQL for yourself!

Stew