auto calculate fields

[talpel]

Hello,


I'm creating a basketball league data base, and I have a table with all the match-ups in the league.
In the field [home team score] and [away team score] there will be the score, and I want to add a field for
"points gained for home\away team" which will calculate which one is bigger (home or away score) and fill with the numbers 1/2 (as in a real basketball league)

I tried to create a new field with "Calculated" data type, but wasn't able to write what I wanted.

it should be smth like
=1 if [home team score]<[away team score] else =2

Can you help me build this expression for the Expression Builder??

Thanks!

[JoeM]

You should do this in a Query, not in a Table. The newer versions of Access do allow for calculated fields in Tables, but it is not recommended to put your calculations there. Other relational database programs do not allow for calculated fields in tables.

You want to use an Immediate If statement (see: https://support.office.com/en-us/art...rs=en-US&ad=US)
Your expression would look something like:

PointsGained: IIF([home team score] < [away team score],1,2)

[talpel]

Thank you very much!