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
 
Back
Top