How do I display records in a query that DO NOT contain criteria

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

Guest

I have a database of customer information and the towns they live in. How do
I ask the query to give me all the records of people who do NOT live in
'Whangarei' - so display every record that does not contain the town
Whangarei. I have searched the wild card character help but cannot find the
answer.
 
Thank you that really helped!

Van T. Dinh said:
SELECT *
FROM [YourTable]
WHERE [Town] <> "Whangarei"

--
HTH
Van T. Dinh
MVP (Access)



Debba said:
I have a database of customer information and the towns they live in. How
do
I ask the query to give me all the records of people who do NOT live in
'Whangarei' - so display every record that does not contain the town
Whangarei. I have searched the wild card character help but cannot find
the
answer.
Click to expand...
Click to expand...
 
Back
Top