Counting

  • Thread starter Thread starter Emma
  • Start date Start date
E

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?
 
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.
 
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
 
Back
Top