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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
thx for the reply but Im a rookie for Access so could you provide a sorta
step by step instruction? Thx a lot
 
Back
Top