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