[AccessD] Avoiding Duplicates on a Report

Create the query, with just the customer number and product number,
grouping by customer and product number? 

-----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 10:13 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Avoiding Duplicates on a Report

 
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.

Thanks,

Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit


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