sum totals

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

 

[Duane Hookom]

Create a totals query that calculates your counts. Then use this query as
the basis for a report.