Total

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

Guest

I am wondering how I can total up the number of specific records in a query.
I have several different locations and i want to know how many records there
are for each location?

Thanks
 
You can do a query of the table, and then use the Totals button (the
funny-looking E). Put the Location field into the query twice, then click
totals, and set one of the functions to Count, while leaving the other as
Group By. This will give you the number of records, for each distinct
Location.

Good Luck.

Sharkbyte
 
use the Totals button (the funny-looking E).

LOL! You mean the Capital Sigma? Sorry, I couldn't let that one go. :-)

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS."
-- General Barringer, "War Games"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show several values within one query cell 2
Records Created Sum per Day 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
field Null but not Null 9
How do I group and count contents of each group? 1
Count in a query 2
Access Updating inventory levels 0
Access Dcount (multiple criteria) 3

Back
Top