Counting Records

[Yaj]

Hi,
I am using Access 2003 on XP.

I wanted to know how to count the amount of records that you have based on a
certain category. My database has one table with people's information in it.
One piece of information is a category(what business type they're in (eg.
Autos, telephone) which has it's own table. When i go to that category table,
there are plus signs (+) on the left side of the records that open up when
pressed and show which people belong under that specific category. (when i
press the Auto plus button, all of the people that work in that field are
displayed)

is there a way that i could add the people up based on what category they
are in?

j

 

[John W. Vinson]

Hi,
I am using Access 2003 on XP.

I wanted to know how to count the amount of records that you have based on a
certain category. My database has one table with people's information in it.
One piece of information is a category(what business type they're in (eg.
Autos, telephone) which has it's own table. When i go to that category table,
there are plus signs (+) on the left side of the records that open up when
pressed and show which people belong under that specific category. (when i
press the Auto plus button, all of the people that work in that field are
displayed)

is there a way that i could add the people up based on what category they
are in?

j

First off, DON'T interact with data in table datasheets. That's not what
they're for! Tables are "bins" to store data; to display, count, edit, etc.
records you need Queries and Forms.

To count the number of people in each category create a Query with the new
query window. Select the People table; include its primary key and the
category field. You may want to also add the category table to the query and
select the category name (the human-readable text rather than the numeric ID).

Click the Greek Sigma icon - looks like a sideways M. Leave the default Group
By on the category fields, and change it to Count on the People table key
field.

Open the query by clicking the datasheet icon on the left end of the toolbar
and you'll see a count for each category.

John W. Vinson [MVP]

 

[Jerry Whittle]

Use a Totals query based on the table. Sum the People and Group By Autos.