distinct count?

[rrmcguire]

I have a set of sales calls records where a sales rep may visit a customer more than once in a day for a particular date....what Im trying to do is just count one of those records as we're trying to determine the number of sales trips made.

ex. have for customer A:

3 sales calls records each with the trip date of 5/3/2005, but only want to count one of them, there is also the possibility that that same customer may be visited again, for example on 5/25/2005

How would I account if there are multiple call records made on the same date to count only one?

thanks

 

[kray4660]

if you have a running total that does a count on customer and evaluates when the date field changes, then that(from the limited information you provided) should work.

 

[lbass]

You could concatenate the date and customer name in a formula:

{table.date} & " " & {table.customer}

Then insert a distinctcount on this.

-LB

 

[kray4660]

lbass as usual you come up with a better solution. And I have done formulas like that too.

 

[rrmcguire]

got it working, thanks everyone