Nicholson, Karen
cyx5 at cdc.gov
Thu May 19 09:33:57 CDT 2005
Ouch. It doesn't sound normalized, but you could cheat and concatenate the six fields into one, and then put the criteria on the concatenated field. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Thursday, May 19, 2005 10:30 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Avoiding Duplicates on a Report This makes me think your table's not normalized. Is this the case? Susan H. This don't work because the product I search for could be in any of 6 fields, Product1 thru Product6. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com