arthurh88
asked on
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'
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'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I fit's anything with the word block then Not Like "*Block*"
Gary