Adding calculations to a form.

[FFLKing]

What I am trying to do is hard to explain but I am going to try and explain it as best as possible. I have a form that I enter football stats into for my FFL league. For the sake of simplicity I am going to focus on the completions(comp) field. I want to add a text box/label to the bottom of the page that will calculate bonuses; if comp<25=0 if comp<50=1 else 2.



I also want to have the CompBonus field then be entered into a new table so I can track bonuses for each player as well, but I think that will be in a new post.

Thank you in advance for the help,

[rzw0wr]

Try the Iif() function.

IIf(expr, truepart, falsepart)

=Iif([comp]>25 AND [comp]<50,1,0)

Use this in you Control Source.

Dale

[FFLKing]

Thanks. I was typing in the Excel Function IF() when I first tried it. I dont know why they had to add the extra I in Access.

[rzw0wr]

They also have an If.
Iif() is for SQL.

Dale