Power Tip: Exclude data from a query by using a table (1 Viewer)

Today’s Power Tip comes from Bob Larson of BTAB Development. Bob is a former Access MVP (2008-2009, 2009-2010), and offers a host of tips and code snippets on his site.

If you have a long list of items to exclude from a query, and you don’t want to type a big IN statement in the query to exclude them, you can use a table to do the exclusions instead. I have posted a short screenshot-based “Quick Tutorial” on my site that shows you how:

http://www.btabdevelopment.com/ts/tbl2exclude

Enjoy!
Bob

Click to expand...