Heenan, Lambert
Lambert.Heenan at AIG.com
Thu Jul 24 08:13:26 CDT 2008
That would be a straightforward Unmatched query for which there is a wizard when you hit the New button in the query window. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, July 24, 2008 4:57 AM To: Access Developers discussion and problem solving Subject: [AccessD] SQL - Alternative to using NOT IN Clause Hi Guys, Somebody posted an alternative to NOT IN (something to do with testing for nulls) but for the life of me, I cannot find it now that I need it. Could anybody help me out here please. Thanks Max -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com