generating sum totals

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hi there

I use Access 2000 for a very simple database of members.

I am reasonably confident with generating queries and
reports showing me lists of e.g. male or female members,
or of cities where members live, but what I would like to
be able to do is generate a report that tells me how many
men or women, or people in a particular city we have.

Can anyone tell me how to do that?

Thanks

Steve
 
Hi Steve

You should be able to meet your requirements using the Group By in your query.

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc
 
Steve, I believe what Maurice was talking about was making your query a Totals query. You can click
the big E looking character on the toolbar while in query design mode or click the View/Totals from
the main menu, After you do that set the GroupBy under the Gender and City field. Add the gender
field again to the end of the query and under it select Count. Now the results will be for example:

Male Tucson 2000
Female Tucson 2500
Male Topeka 100
Female Topeka 85
etc.

Hope this helps.
 
Hi. How can I do the exact same thing but with percentages?

Oh, and even though I can get the "total female" "total male" I cannot get
the plain "total" (f+m)

greetings.
 
Nick, to get the total f&m by state, design a new query using the totals query you created above as
the source for the query. Make this a totals query as well drag the State field to the query and
set it to GroupBy. Add the CountofF_M field to the query and select Sum under it. Results:

Tucson = 4500
Topeka = 185

If you just want a total count just do a totals query. Add the primary key field to the query and
under it select Count. Result:

Total = 4685

Not sure what you're asking on the percentages. Could you provide some more detail and maybe I can
help.

Hope this helps!
 
Not sure what you're asking on the percentages. Could you provide some more detail and maybe I can
help.
Click to expand...

Ok. A simple example would be:
Tucson: 95%
Topeka: 5%

The complex version would be:
Tucson: Male 40%
Female 60%
Topeka: Male 57%
Female 43%

Thanks anyway. The former tip was quite helpful.
 
Nick said:
Hi. How can I do the exact same thing but with percentages?

Oh, and even though I can get the "total female" "total male" I cannot get
the plain "total" (f+m)

greetings.
Click to expand...
 
Back
Top