Calculation for a result between two teams
I have a sports league database where I am able to import a series of stats and game scores. Each game has a unique number (GameID) so for each game their will be two records - one for each team. Each record will include a score field. Is there an easy way that I can write a calculation so that a result field will give either Win, Loss or Draw depending on the score for that team for that game.