C
Colleyville Alan
I have a pivot table that gets its data from Access. My table in Access has
about 20,000 records, with 1,500 unique account numbers having 10 to 20
pieces of account detail info each.
When I use the pivot table, putting any distinct item in the data portion of
the table and counting it gives me a count of 20,000. But there seems no
way within the table to say "count only the distinct items" which would give
me a count of 1,500. Is there a way to do that, or do I need to restrict
such queries to MS Query or Access?
I suppose what I want is the count I would get if I manually added up the
description data in the row fields:
Acct $amt
A 50
B 75
C 40
D 30
This might be from a file that has 20 instances of "A", 30 of "B" and so
forth. If I wanted to know how many accts I had, I'd just look and say
"there are four" because I can easily spot that A,B,C,D are four unique
accts. But with 55 accts in one region and 39 in the next, it is not an
easy process. But that convoluted explanation may give you an idea of what
I am looking for.
about 20,000 records, with 1,500 unique account numbers having 10 to 20
pieces of account detail info each.
When I use the pivot table, putting any distinct item in the data portion of
the table and counting it gives me a count of 20,000. But there seems no
way within the table to say "count only the distinct items" which would give
me a count of 1,500. Is there a way to do that, or do I need to restrict
such queries to MS Query or Access?
I suppose what I want is the count I would get if I manually added up the
description data in the row fields:
Acct $amt
A 50
B 75
C 40
D 30
This might be from a file that has 20 instances of "A", 30 of "B" and so
forth. If I wanted to know how many accts I had, I'd just look and say
"there are four" because I can easily spot that A,B,C,D are four unique
accts. But with 55 accts in one region and 39 in the next, it is not an
easy process. But that convoluted explanation may give you an idea of what
I am looking for.