A
Andrew Tatum
I'm trying to come up with a pretty advanced (I guess) field in a form.
Basically, I want it to check for something before giving a total.
Here's the outline:
IF [MsgLeft] > 1 THEN [MoneyOwed] = 0.00
ELSE
IF [MsgLeft] < 1 THEN [MoneyOwed] = [TotalBookedAmt]-[MoneyUsed]
Whenever I try to do that as a Control Source and then paste it into
Expression Builder it just goes blank. It's like Access doesn't even
accept that. So, I'm thinking that I'm doing something wrong.
Any suggestions?
Basically, I want it to check for something before giving a total.
Here's the outline:
IF [MsgLeft] > 1 THEN [MoneyOwed] = 0.00
ELSE
IF [MsgLeft] < 1 THEN [MoneyOwed] = [TotalBookedAmt]-[MoneyUsed]
Whenever I try to do that as a Control Source and then paste it into
Expression Builder it just goes blank. It's like Access doesn't even
accept that. So, I'm thinking that I'm doing something wrong.
Any suggestions?