Hi,
I have been searching all day on how to count duplicate record once but no luck. I have a form with list of records but sometimes same customer id is used. I want to have a unbound txtbox to show
- number of Active Status with L90 field counted once
- number of Closed status with L90 fields counted once
I tried to do it through query but don't know how to tell the query to count only once for L90 field.
any recommendation on how I can do this easily?