Grouping and Counting

[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

 

[Ozzie via AccessMonster.com]

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

 

[John Spencer]

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.