How to count the number of certain item in a column?

[wudai_e]

Hi everyone!

I want to count the number of a certain item in a form column.

For example, in one column, I have values ranging from 1-5, how do I
seperate and count the number of 1s, 2s, and so on?

Thanx alot!

 

[Rick Brandt]

Hi everyone!

I want to count the number of a certain item in a form column.

For example, in one column, I have values ranging from 1-5, how do I
seperate and count the number of 1s, 2s, and so on?

Thanx alot!

Totals query.

SELECT FieldName Count(*) as Qty
FROM TableName
GROUP BY FieldName

 

[wudai_e]

thx for the reply but Im a rookie for Access so could you provide a sorta
step by step instruction? Thx a lot