By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

Count some data in same field in ms access

P: 1
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' on.
Mar 21 '14 #1
Share this Question
Share on Google+
3 Replies

P: 4

P: 5
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.
Mar 21 '14 #3

Expert Mod 5K+
P: 5,397
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.
Mar 26 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.