How do I run a query and exempt certain numerical values?

G

Guest

I want to create a query that lists values. I have 4 values I don't want to
include in this particular query. ie: 10, 20, 30, 40, 50, 60, 70..... etc..
I want to exclude 10, 20 and 40 from the data. How do I do that?
Thanks!
 
D

Duane Hookom

Create a table of these values. Add a criteria under this column like:
Not In (SELECT [ExcludeValues] FROM tblYourNewTable)
If you already have a table of all these values, add a field that can be
used to limit your records.

I would not create an expression that included the hard-coded values since I
expect the values may change over time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset and Small functions with blank rows? 0
Help with complex query 1
Query to calculate quarterly rolling value 1
Query that picks different column from a table based on the inp va 3
Help creating updateable query 6
Tough PIVOT problem 1
DSUM Function 2
How do I do this? 3

Top