Count Sports

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • peckington
    New Member
    • Oct 2006
    • 1

    #1

    Count Sports

    I need to create a report that counts the amount of sports that people do.

    I have the MemberID and SportID in diff tables linked in via a realtionship.

    anyone have any idea how i can do this?
  • bum bum
    New Member
    • Oct 2006
    • 1

    #2
    To quote Freddy Got Fingered:

    "You could stick the cheese in your bum bum"

    As for your actual problem, have you considered another type of database?

    I could tell you easily how to do this using a PHP/MySQL combination.

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      Originally posted by peckington
      I need to create a report that counts the amount of sports that people do.

      I have the MemberID and SportID in diff tables linked in via a realtionship.

      anyone have any idea how i can do this?

      1) Create a Totals Query:
      2) Group By MemberID
      3) Count of SportID
      4) Use this Query as the Record Source for your Report

      Comment

      Working...