Total

I

IS

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
 
S

Sharkbyte

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
 
M

Mike Labosh

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"
 
Top