By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 1,077 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Count Sports

P: 1
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?
Oct 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: 1
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.
Oct 18 '06 #2

ADezii
Expert 5K+
P: 8,619
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
Oct 18 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.