Returning unique values in report

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

i have a report that finds a salesrep and calculates
certain data based on a date range. the problem i am
having is totaling the number of unique customers, i keep
getting the total number of customers - even the customers
that have made multiple purchases. thanks in advance
Frank
 
Hi Frank.
You can create a separate query with just the customers,
or customers and salesrep and set the property for the
Unique value to yes.
Hope this helps
Fons
 
Back
Top