Counting duplicated dates only once by customer

[Enigma20xx]

I have many receipts, some are paid by one pay others by two or three payments.

I use the same date for the same receipt, so I’d like to count them as one.

I.e.

ReceiptDate Customer Amount DateOfPayment

08/10/2012 100 $25 08/10/2012

08/10/2012 101 $32 08/10/2012

08/10/2012 100 $20 08/12/2012

08/10/2012 102 $15 08/16/2012

09/10/2012 100 $14 09/10/2012

Customer 100 -> 2 (08/10/2012 and 09/10/2012)

Customer 101 -> 1 (08/10/2012)

Customer 102 -> 1 (08/10/2012)

Can anyone point me in the right direction?

Thank you.

[LaRetta]

Hi Enigma,

Go to your graph and create a duplicate table occurrence of your table, naming it something like 'customer receipts' and join them as:

MainTable::ReceiptDate = CustomerReceipts::ReceiptDate

and

MainTable::CustomerID = CustomerReceipts::CustomerID

Now create a summary field which is count of the unique ID (or any field guaranteed never empty) maybe calling it sCountIDs. Now place CustomerReceipts::sCountIDs on your layout. :-)

[Enigma20xx]

Thank you very much LaRetta for your answer.

I was almost there but what I was doing wrong was using the field sCountIDs from the MainTable not from it's TO.

The thing is that it doesn’t really do what I try to accomplish.

Now tells me how many times a customer paid to complete a receipt.

But how can I count the receipts paid?

I need all the dates of payment for the same receipt counted as one.

If he has paid 3 times to complete the first receipt and two to complete the second, now I can see that, but I can’t see he has paid 2 receipts (in 3, 4 or 10 payments).

Thanks again.

CountingDatesOnce.zip