Microsoft Office Pro Plus 2007 Power Tip Exclude
 

Today’s Power Tip comes from Bob Larson of BTAB Development. Bob is a former Access MVP (2008-2009,Microsoft Office Pro Plus, 2009-2010),Microsoft Office Pro Plus 2007, 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,Office Professional Plus, and you don’t want to type a big IN statement in the query to exclude them,Office 2007 Professional, 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: Enjoy,Office Professional!
Bob Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div