asked on

if...then

ok, I'm totally lost when it comes to programming access. So
here's what seems so simple but doesn't work for me. (Access 97): Let's keep it
simple. I have 3 fields on a form (from a table). The fields are "subtotal", "tax", and
"total". The "tax" field is a check box (yes/no). My expression in the "total" field
states: Iff([tax]="yes",[total]=(.07*[subtotal]),
[total]=[subtotal])
I'm getting to old for this. Basic was easy for me, this is not.
J. Hinely

Willtry

I am no expert by any stretch, but I don't think you want to use an immediate If statement in your example, I would think that you would use an If then statement. Instead of using the expression builder, try using the code builder.

If([Tax]="yes", then
[Total]= 0.07*[Subtotal]

I think this might work for you.

ASKER CERTIFIED SOLUTION

jconde

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TerryEllis

Try it like this IIF([tax],[total]=(1.07*[subtotal]),[total]=[subtotal])

tuvi

You don't need the [total]= part. Try this:

IIf([tax],(1.07*[subtotal]),[subtotal])

toys032498

Great peace of code Tuvi and TerryEllis, I forgot all about IIF, thanks for the reminder.

TerryEllis

tuvi, your right on about not needing the "[total] = part". Thank you for the correction.

jrhinely

ASKER

Thanks, guys. I wish I could award all of you some points. Actually "tuvi" had what I used.

jconde

Guess tuvi deserves the points uhhh!

Tuvi, I'll post an answer worth 50 points so you can get them!

Later
Jorge