• It doesnt seem to work. It is still displaying all the customers.

    Basically what I want is,eg day 1 -7. day 7 must show only the unique customers, which means that the customers between day 1 - 6 must not be displayed in day 7. The same goes for day 6 , must not have day 1 - 5 customers in it.

    But I want to display the number of customers, and not the actualy names. Eg

    Day 1 : 5 Unique customers

    Day 2 : 2 Unique customers

    Day 3 : 0 Unique customers(which means that the same customers in Day 1 and 2 might have done some transactions

    Day 4 : 15 Unique Customers(this is excluding day 1 - 3' customers)

    ect.

    any ideas how ?