[AccessD] Avoiding Duplicates on a Report

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




More information about the AccessD mailing list