Count some data in same field in ms access

[dharmasiri66]

I have a data base in MS Access .There is a field named "Age" I want to count how many persons age 35,34,33'...so on.

[Kaloka]

Group by is your keyword http://office.microsoft.com/en-001/a...001231482.aspx

[Tom Murphy]

1.Create a select query and include the table containing "Age.
2.Drag Age to the field row in first col.
3.Drag another field (key field) to the field row in the second column.
4.From the ribbon in the Show/Hide section click on Totals to show the Total row in the query grid.
5.In the dropdown in the first column total row select Group By.
6.In the dropdown in the second column total row select Count.
Run the query. Will get the age in the first column and the total for that age in the second column.

[zmbd]

You can use the [AGE] field in both columns, this way you will by default get a field named [Count of AGE] when the query is ran.

Kaloka, although your link is technically correct, for someone that doesn't know how to write SQL, which is what OP's post indicates, the following link may be a better fit:

Count data by using a query (ACC2007/2010)

The process is much the same in earlier versions; however, the location of total toggle varies a little bit.