Counting

[Emma]

Hi I have a field called Income with values such as employeed full time, part
time etc.. I would like to count the number of times these values are in the
table. I tried using a count query in the Income file but it just returns 1's
for each person. How can I get the value for each category?

 

[BobT]

What you need is to group by as well as count. So, add your Income field
twice; click on the TOTALS button (looks like the Sigma symbol - which you
may have already clicked on); then in the first Income field choose GROUP BY
and for the second field choose COUNT. This will give you the counts per
Income.

NOTE: If you have ANY other fields selected as well, it counts the unique
combinations, which could be causing your records to only show 1's.

 

[Lord Kelvan]

try soemthing like

SELECT Count(income) AS CountOfincome, income
FROM tblincome
GROUP BY income
HAVING (((income)="employeed full time")) OR (((income)="part
time"));

Regards
Kelvan