-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Equivalent to Countifs in an Access query
- Thread starter FryGirl
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,459
- Office Version
- 365
- Platform
- Windows
Just do an Aggregate (Totals) Query in Access, grouping on your ProjectID and Steps fields, and counting any other field.
To do this:
1. Create a new query in Access
2. Add the ProjectID, Steps, and any other field to your query (you can even choose the ProjectID to Steps field again)
3. Click on the Totals button (looks like a Sigma). This will add a Totals row under each field in the Query Builder.
4. Under your third field, change the "Group By" value on the "Totals" row to "Count"
5. View your result.
To do this:
1. Create a new query in Access
2. Add the ProjectID, Steps, and any other field to your query (you can even choose the ProjectID to Steps field again)
3. Click on the Totals button (looks like a Sigma). This will add a Totals row under each field in the Query Builder.
4. Under your third field, change the "Group By" value on the "Totals" row to "Count"
5. View your result.
Upvote
0
Similar threads
- Solved
- Question
