Your topic makes me think you already know...Use NOT IN in your SQL statement.
SELECT * FROM Table WHERE ID NOT IN (#quotedValueList(flaggedRecordSet.id)#) -- jon mailto:[EMAIL PROTECTED] Wednesday, September 18, 2002, 12:46:21 PM, you wrote: KP> I have 2 queries one that contains the enitre recordset of the table and KP> 1 that contains my flagged results. KP> What I need to do is find a way to display all of the records that KP> aren't part of query #2's recordset. KP> Please help KP> KP KP> Kris Pilles KP> Website Manager KP> Western Suffolk BOCES KP> 507 Deer Park Rd., Building C KP> Phone: 631-549-4900 x 267 KP> E-mail: [EMAIL PROTECTED] KP> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
