Where Field NOT IN #ValueList(query1.field)# -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:46 PM To: CF-Talk Subject: Not in?
I have 2 queries one that contains the enitre recordset of the table and 1 that contains my flagged results. What I need to do is find a way to display all of the records that aren't part of query #2's recordset. Please help KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ______________________________________________________________________ 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
