Guest_imported
New member
- Jan 1, 1970
- 0
Ive got a query that builds results like this:
Field1 etc...
A
B
A
A
C
A
A
I want to generate a report and have a text field that counts the UNIQUE values in Field1. In this example =Count([Field1]) yields 7 (A,B,A,A,C,A,A)when I want it to yield 3 (A,B,C). Is there an easy way to do this? Something else besides =Count([Field1]) ?
Field1 etc...
A
B
A
A
C
A
A
I want to generate a report and have a text field that counts the UNIQUE values in Field1. In this example =Count([Field1]) yields 7 (A,B,A,A,C,A,A)when I want it to yield 3 (A,B,C). Is there an easy way to do this? Something else besides =Count([Field1]) ?