Grouping and Counting

  • Thread starter Thread starter Ozzie via AccessMonster.com
  • Start date Start date
O

Ozzie via AccessMonster.com

My problem is such;

I have a query which I have switched on the groupings function. The first
few columns of data I group, the other few I count... easy enough, however,

when the count returns the result, each column count is the same, for some
reason it is summing up the total and not the true count of the column of
data; ie

ColumnA ColumnB ColumnC ColumnD
a 1
b 1

c 1
d

e 1 1
1

my query would return a count of 5 for column B, C, D instead of returning a
count of 3 for ColumnB, 2 for ColumnC and 1 for ColumnD.

Anyone know what I am missing??

Cheers
 
Can anybody help?????
My problem is such;

I have a query which I have switched on the groupings function. The first
few columns of data I group, the other few I count... easy enough, however,

when the count returns the result, each column count is the same, for some
reason it is summing up the total and not the true count of the column of
data; ie

ColumnA ColumnB ColumnC ColumnD
a 1
b 1

c 1
d

e 1 1
1

my query would return a count of 5 for column B, C, D instead of returning a
count of 3 for ColumnB, 2 for ColumnC and 1 for ColumnD.

Anyone know what I am missing??

Cheers
Click to expand...
 
It would help if you posted the SQL of your query.

Select View: SQL from the menu in design mode. Copy and paste the sql.

Also, what are the column types (are they numeric, text, date, boolean)?

Count - counts each time it detects ANY value in the field. So if ColumnB
has a zero-length string in it, it gets counted just as if it had "1" or "A"
in it.
 
Back
Top