generating sum totals

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


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

Thanks Maurice

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

Thanks again

Steve

-----Original Message-----
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


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





.

Steve,

There is a good article on the Microsoft Office website
about counting in a report. Here is the link.

http://office.microsoft.com/assistance/category.aspx?
CategoryID=CH011232671033&CTT=6&Origin=HA011377631 033

Hope this help.

John Parkinson

-----Original Message-----
Thanks Maurice

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

Thanks again

Steve

-----Original Message-----
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


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





.

.

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.

--
Reggie

----------
wrote in message
...
Thanks Maurice

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

Thanks again

Steve

-----Original Message-----
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


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

--
Reggie

----------
"Nick" wrote in message
...
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.

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

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" wrote in message
...
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.