A SQL guru may come up with something better but you could put them all into your own query structure and get the distincts from a QoQ there
..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 1:29 PM To: CF-Talk Subject: Getting Distinct Values across multiple fields I have a database that contains fields such as the following: Code1, Code2, Code3, Code4, Code5..... Code25. I need to return the distinct codes from ALL columns. I don't care if a code only appeared in one of the columns, I need to see it in the distinct list. I know that I could return a distinct list of EACH field, and then add all of those together and get a distinct list of the result, but is there a more elegant way to do this? CF7 and Access2k2 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
