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