Help! Not criteria

A

Andrea McKee

I need to exclude all records have a particular value. Using the criteria
not like "steve" does filter out all of the Steves, but it also filters out
all records where first name is null. Any idea how to work around this
behavior????

I'm at a loss
Thanks in advance
Andi McKee
 
M

Michel Walsh

Hi,


In SQL view:

.... WHERE Nz( NOT MyField LIKE pattern , -1 )

or


.... WHERE Nz( MyField <> value , -1 )



Hoping it may help,
Vanderghast, Access MVP
 
J

John Vinson

I need to exclude all records have a particular value. Using the criteria
not like "steve" does filter out all of the Steves, but it also filters out
all records where first name is null. Any idea how to work around this
behavior????
Click to expand...

Where [namefield] IS NOT NULL And NameField <> "Steve"

There is no benefit to using the LIKE operator if you're not using
wildcards.

John W. Vinson[MVP]
 
Top