Discussion Locked

Access 97 Multiple Counts

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please Email a copy of your reply to: MRA2@mindspring.com

I have an Access97 Membership database. Each member can have a Basic, Silver, Bronze or Gold Membership category. Each has a different membership fee.

I want to print out a Summary report (NO DETAIL LINES) and show how many members are in each membership category and how much I collected for each category. I want them all on the same sheet!

Can you help??? Please Email a copy of your reply to:
MRA2@mindspring.com

3 replies

by kees.valkenswaard

Suppose you have the following fields [you should have more]:
Mem-ID
Type
Subscription [numeric or better currency]
Make a query based on this table.
Use the sum-button [Sigma, the same sign as auto-sum in Excel]
Put in the grid the field type[silver, etc]
It will automatically get Group by [in the total line]
Add the same field with count
Add the field Subscription with sum
That is all.
Just print the query result.
If you want to make it fancy you can make a report [even an auto report] based on this query.
Good luck

This discussion is closed to new replies.