Exclude Records

[lakes_it_guy]

Sweet thanks mann! Another quick ?, my employer just now told me that I needed to exclude certain values in the table im working in. The columns that hold the values that im suppose to exclude in my report are as follows: id, lotNumber, and Meter Serial Number.Ive never tried to exclude certain values in a table im querying in. The only way I can think of it working correctly is to query for the values i need to exclude then subtract that total from my total gallons metered value. Any help would be greatly appreciated. Thanks in advance mate!

 

[Joe4]

I moved your latest question into its own thread, as unless the question is directly related or dependent upon the previous answer, new questions should have new threads (so they will appear unanswered to other members).

You can exclude values in criteria. For example, if you want to exclude values that do not equal 10, that criteria would look like this:

<>10

For multiple fields, just add on your exclusions on the same line under each field you are applying the criteria (same line means treat it as an "AND" condition, separate lines means an "OR" condition).

If your issue is a bit more complex, it may be helpful for post a small sample/example.

 

[lakes_it_guy]

Sweet thanks a lot man! I wish I could give you more cred. You have helped me come a long way since I started working in Access, which was like a couple weeks ago lol. Enjoy your day mate! I will most likely not bother you with anymore questions today. But be on the look out for a new thread made by me lol Cuz im sure something will come up. Have a great Tuesday

 

[Joe4]

Your welcome! Glad to help!