generating sum totals

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
 
S

StCyrM

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
 
G

Guest

Thanks Maurice

Sorry for being a numptie, but I cannot find Group By?

Thanks again

Steve
 
R

Reggie

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.
 
N

Nick

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.
 
R

Reggie

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!
 
N

Nick

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