Need help with a query, PLEASE!!

[BlueButterfly]

Hi guys,
At present i am creating a database on a soccer club....i have to input scores frm the home team and opposing team and determine in a query whether the game was a win, loss or draw.....i have tried several ways but as yet have only been able to come up with a win and loss although some teams did draw their game....hoping someone can help me as i am very new at this

 

[andyparker]

Hello BlueButterFly,
Appearently your situation requires a select Statment With a condition operator such as <,>,<>,= in the Where Part.The Fields You can use to compare will be scores of both the teams and generate reports.