Subtraction

[nx69]

Substraction

I want to built up a query that will substract the value of a field from another. Ex. The "Amount of units to bet" field in frmBets, is 5, i want this value to be substracted from the "Units" field in frmMembers.

Also i want another query that will check a check box when it runs.

Thanks.

 

[Uncle Gizmo]

field in frmBets, is 5

Do you mean text box on frmBets is 5? If so the other field you mention is also a text box, No?

If true, then where do you want the answer to appear...

 

[nx69]

Do you mean text box on frmBets is 5? If so the other field you mention is also a text box, No?

If true, then where do you want the answer to appear...

Both fields are text boxes.
The field is frmBets shows the amount of units the members wishes to bet, and the field in frmMembers the units owned by the member. So i want the value of the field in frmBets to be substracted from the value of the field in frmMembers, showing the units left. e.g. If he bets 10 units(field in frmBets) and he has 110 units in account(field in frmMembers), the field in frmMembers should now be 100.