Hopefully a simple query

  • Thread starter Thread starter Michael Beatty
  • Start date Start date
M

Michael Beatty

I have three tables that I'm merging together tblPlayer, tblPlayerStats,
tblOpponent. I'm trying to get a query that shows the lowest score for each
opponent. The query I have now shows each player and each score against
each opponent example
The Player is comming from tblPlayer.fldPlayer the
The Score is from tblPlayerStats.fldTotalScore
The Opponent is from tblOpponentStats.fldOpponent

Player Score Opponent
Joe Schmoe 82 Team1
Jim Slim 83 Team 1
Jack Sprat 84 Team 1
Jim Slim 88 Team 2
JoeSchmoe 84 Team 2
Jack Sprat 89 Team 2

The output I am looking for is
Player Team 1 Team 2
Joe Schmoe 82 84
Jim Slim 83 88
Jack Sprat 84 89

I'm not overlly framilar at SQL this is for a VB program for a college
class. We are working in a group as a team and our access query team member
is a dud (shows up half the time and dosn't do anything if he does show up)
Any help that you can give would be great, even if it's just pointing me to
a good reference source. Thanks
 
Try a crosstab query where Player is the Row Heading, Opponent is the Column
Heading, and Min of Score is the Value.
 
Back
Top