[AccessD] Avoiding Duplicates on a Report

Or if the data on the report is tabular, you could set the hideduplicates
property of the text box to true.

Bobby

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