Counting data within a field

[Sandy Coulter]

I am working on a membership database and wish to count the
number of members with specific membership classifications,
i.e., the number of active members, number of sustaining
members, etc. The totals of each classification are to be
output to a report. I can't seem to find a solution to
this in two thick manuals that I have.

Can some kind soul please advise me on this?

 

[Ken Snell]

You want to use a Totals query.

Open a query in design view and select the table that has the members' info
in it.

Put the MemberID, MemberActive, MemberSustaining, etc. fields on the query
grid. On the toolbar, click the "Greek letter Sigma" icon (this makes the
query a totals query). Under the MemberActive and other fields for which you
want a count, change "Group By" to "Count".

That should get you started.