Help! Not criteria

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

Guest

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
 
Hi,


In SQL view:

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

or


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



Hoping it may help,
Vanderghast, Access MVP
 
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]
 
Back
Top