Forums
This topic is locked
How to Make Access to decide?
Posted 29 Sep 2001 23:43:05
1
has voted
29 Sep 2001 23:43:05 Ahmad Fariz Hanapiah posted:
Say I have 4 fields that is :HomeTeam, AwayTeam, HomeScore, AwayScore.
From that I want access to decide which one won, draw and lose into another field in a query.
Say a simple basic code would be like this
If homescore>awayscore then
hometeam win
end if
But I dunno how to implement this in access.
Any ideas?