I run a Madden online league (Nintendo Wii)
I am stuck on how to run a query or report that calculates STANDINGS.
W - L - PCT - GB - PF - PA - DIV WL - CONF WL
W - Wins
L - Losses
PCT - Winning Percentage
GB - Games Behind
PF - Points Scored
PA - Points Allowed
DIV WL - Divisional Games Won Lost
CONF WL - Conference Games Won Lost
I have a Table that lists all the players, but I have two separate fields in my table for Winners and Losers, maybe that's a problem.
With the current setup I can run cross tab queries to obtain the number of wins a player has and his points, as well as number of losses and points. But I get bogged down with errors when I try to combine them in a Standings format. (both queries and report errors)
I have Access 2007.
Any help that nudges me in the right direction would be greatly appreciated.
PS - I haven't used Access in 2 and half years, and that was Access 97 where I used to work. So I am a bit rusty.
I am stuck on how to run a query or report that calculates STANDINGS.
W - L - PCT - GB - PF - PA - DIV WL - CONF WL
W - Wins
L - Losses
PCT - Winning Percentage
GB - Games Behind
PF - Points Scored
PA - Points Allowed
DIV WL - Divisional Games Won Lost
CONF WL - Conference Games Won Lost
I have a Table that lists all the players, but I have two separate fields in my table for Winners and Losers, maybe that's a problem.
With the current setup I can run cross tab queries to obtain the number of wins a player has and his points, as well as number of losses and points. But I get bogged down with errors when I try to combine them in a Standings format. (both queries and report errors)
I have Access 2007.
Any help that nudges me in the right direction would be greatly appreciated.
PS - I haven't used Access in 2 and half years, and that was Access 97 where I used to work. So I am a bit rusty.