Help with query-dont want to see dupes

[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

 

[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

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]

 

[Rob]

Nice, thanks.

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]

 

[i_takeuti]

Nice, thanks.