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

W

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!
 
R

Rick Brandt

wudai_e said:
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!
Click to expand...

Totals query.

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

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
 
Top