Getting a count of various records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db on a swimming pool and each member can have a different type of
membership...so I would like to know how many members belong to each type of
membership. I tried adding the fields to a query...membertype, memberid,
lastname, and then using count but it didn't seem to work. I also tried a
report using totals but that didn't work either...I obviously need your
assistance. Thanks in Advance!

Vanessa
 
Base your report on a query. Make sure that MembershipType is an
included field.

In Sorting and Grouping, group on MembershipType. If you want to
display the number you'll find plent of help in Help.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
sorting a report with two tables 1
Quering Table 5
Help creating a report 1
Problems with count, counta and countifs 3
query query 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Is it possible to compare a string and a field name 9

Back
Top