Kevin, It depends what the table(s) you're using look(s) like. If you have multiple fields for food values you could concatenate them together, but I am not sure if that is the case.
Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Fricke Sent: Monday, December 05, 2005 10:49 AM To: CFLIST Subject: [DFW CFUG] queries How do I pull a list of values into one column of a query result? Is this possible? For example, I have a list of reservations. With each reservation there may be a number of food options selected. Is it possible to run a query which will return the following results? ID | Client Name | Food 1,Food2,Food3 | etc. Kevin _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please immediately notify the sender and delete it from your system. _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
