Beginner Query question..... summing...

  • Thread starter Thread starter Morpheseus
  • Start date Start date
M

Morpheseus

I have a basic db. I have a query that pulls out the following
information for people who are working on "work gangs":

Gang #
WorkerID
LastName
Living Unit
Assignment
Comments

I have about 400 workers. There are 30 different work gangs. So I
made this query to pull out say... Gang #12. It looks great. I did a
report based on the query. However, I would like to be able to total
the number of people (rows) reported for the gang that is queried.

I have five books on Access, I have the Keystone Learning systems
tapes and cd's. Do you think I can find the answer? No way. I guess
in my abundant ingorance, I don't even know what to look up. I have
searched: SQL Expressions, Count, Countif, Sum, Total, etc.... in the
various glossaries. That is the problem with books.

That is whats so frustrating about this. I can't get better at Access
until I have a real database to work on. I can't do a real database
because WHATEVER you want to do is cryptic... you can't look it up
because its not called what you think it is.

This is my last resort....

Suggestions folks....

TIA
Nick.
 
Gang #
WorkerID
LastName
Living Unit
Assignment
Comments

I have about 400 workers. There are 30 different work gangs. So I
made this query to pull out say... Gang #12. It looks great. I did a
report based on the query. However, I would like to be able to total
the number of people (rows) reported for the gang that is queried.
Click to expand...

If you just want to display the number of rows on the Report, the
simplest way is to put a textbox in the Report's Footer (you may need
to use the View menu option to make the footer visible). Set its
Control Source property to

=Count(*)

You can also count records using a Totals Query (see the online help
for Totals), and a few other ways as well... but you're right, it is a
jungle out there!

One suggestion: take a look at Northwind.mdb or one of the other
sample databases to see how (some) things can be done. I don't like
everything in Northwind but at least it can give you some ideas!
 
Back
Top