counting number of rows

[k209310]

this is probably asy so forgive me for wasting your time (im not an access/query expert)

Is it possibly to count the number of rows in a record that contain a certain number?

field1
1
1
1
3
3
3
4
4
4


eg i could return something that lets me know there are 3 rows contatin number 1 etc.

Thanks for anyone who replies

 

[CBragg]

Open a new query and add the relevant table.
Add the field you want to query, in the criteria type, in your example "1" and click on the 'sum' button (looks like an E).

A new row will appear, it should currently say 'Group By', select 'Count' instead.

When you run this query you will have 'CountofField1' followed by the numbeof 1's: 3.

Hope this solves it.

 

[browntrout]

How about trying a 'Find Duplicates' query (this will count all duplicated items in the field you have selected, not just one at a time).

And, if you go into Design view and change the criteria from >1 to >0, it will also count singles.

 

[k209310]

thans for the replies. It did the trick.