Help with query-dont want to see dupes

R

Rob

I've made a query to find customers that have ordered a certain product
between a period of time. Some customers order a lot so they'll appear
multiple times but I only want to show each customer once.

The field to compare is ContactID
 
J

John W. Vinson

I've made a query to find customers that have ordered a certain product
between a period of time. Some customers order a lot so they'll appear
multiple times but I only want to show each customer once.

The field to compare is ContactID
Click to expand...

Either use the Totals tool (the Greek Sigma, looks like a sideways M) and
Group By ContactID, or set the Query's Unique Values property to Yes.

In either case you'll need to *uncheck* the Show checkbox on any fields that
will vary from record to record within a customer. This will probably include
the fields used as criteria to find the customer.

John W. Vinson [MVP]
 
R

Rob

Nice, thanks.
John W. Vinson said:
Either use the Totals tool (the Greek Sigma, looks like a sideways M) and
Group By ContactID, or set the Query's Unique Values property to Yes.

In either case you'll need to *uncheck* the Show checkbox on any fields
that
will vary from record to record within a customer. This will probably
include
the fields used as criteria to find the customer.

John W. Vinson [MVP]
Click to expand...
 
Top