[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 838
  • Last Modified:

Access 2007 Query Command Help

SELECT *
FROM Master
WHERE (((Master.[Rejected])=0) AND ((Master.[Remove])=0) AND NOT ((Master.[Notes])  = 'Block'))
ORDER BY Master.City

I'm having problems with the NOT command.  I want all fields displayed where the notes column does not equal 'Block'
0
arthurh88
Asked:
arthurh88
  • 2
2 Solutions
 
DimitrisSenior Solution ArchitectCommented:
SELECT *
FROM Master
WHERE (((Master.[Rejected])=0) AND ((Master.[Remove])=0) AND ((Master.[Notes])  <> 'Block'))
ORDER BY Master.City
0
 
tbsgadiCommented:
Hi arthurh88,

For Access

SELECT *
FROM Master
WHERE ((([Master].[Rejected])=0) AND (([Master].[Remove])=0) AND (([Master].[Notes]) Not Like "Block"))
ORDER BY Master.City;

Good Luck!

Gary
0
 
tbsgadiCommented:
arthurh88,

I fit's anything with the word block then Not Like "*Block*"
Gary
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now