[AccessD] Avoiding Duplicates on a Report

Nicholson, Karen cyx5 at cdc.gov
Thu May 19 13:27:29 CDT 2005


It looks like this was created flat for some reason; maybe because the
user only wants to allow the selection of six items per invoice, but
there are other ways to limit product selections. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, May 19, 2005 2:22 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Avoiding Duplicates on a Report

Hi Mike:

I got into this late and I may not understand these issues but should
not each of the invoice detail items be in their own separate record?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Thursday, May 19, 2005 7:26 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Avoiding Duplicates on a Report

This don't work because the product I search for could be in any of 6
fields, Product1 thru Product6. 


Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit
Office - (541)881-4808
Fax - (541)881-5471
Pager - 1-888-320-2545  epage - 8883202545 at archwireless.net 

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net]
Sent: Thursday, May 19, 2005 8:18 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Avoiding Duplicates on a Report

Won't a GROUP BY on the Customer and Product work?

Susan H. 

 
Here is my scenerio - I have a sales table which records the purchase of
a product by a customer.  It logs the product, cutomer# & Invoice#.  Now
I want to be able to pull from the table all customers who purchased a
certain product.  The part I need help with is trying to pull the
customer only once.  The same customer could purchase the same product
more than once during the month but I only want the query to show me the
customer# & product only once, not multiple times.

Any advice would be greatly appreciated.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
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