[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

SELECT query: do not include

What do I enter in Access to exclude data.  For example, if my data field includes A - Z, but I want to exclude E, M, and Y
0
z018196
Asked:
z018196
1 Solution
 
mbizupCommented:
SELECT *
FROM YourTable
WHERE YourField NOT IN ("E","M","Y")
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
select * from urTable
where urColumn not in ('E', 'M', 'Y' )
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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