Basic Access

[Julie McEwan]

Hi, I have a basic database for a sporting group. I have a list of matches
(approximately 500 matches) to be played. eg. joe versus bob, and greg
versus harry. My question is how do I do a count of how many times bob has
won, or do a report on who has won the most matches, down to who has won the
least.

Thank you

Julie

 

[Larry Linson]

Hi, I have a basic database for a sporting group. I have a list of matches
(approximately 500 matches) to be played. eg. joe versus bob, and greg
versus harry. My question is how do I do a count of how many times bob has
won, or do a report on who has won the most matches, down to who has won
the
least.

Could you please give detail on each Field in each Table in your database?
And if there are two Fields for players in each Match, would the samp player
be in the same Field for each match, or might the player be in either Field?

 

[Julie McEwan]

There are only 3 fields, Player 1: Player 2: and Winner. The player name can
appear in either Player 1, or Player 2. Then I want to be able to put the
winner name in the winner field, and then after all matches are complete, do
a report to see who won the most to least

 

[Rick B]

Sounds like the first two fields are irrelevant. Just run a query pulling
the "winner" field. Count the entries, and sort it.