Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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
0
jrhinely
Asked:
jrhinely
1 Solution
 
WilltryCommented:
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.

0
 
jcondeCommented:
Mabe this code will help you out.
If you have any problems please let me know about it!

Private Sub Tax_Click()
  If Tax = -1 Then             'Tax is checked
    Total =  0.07*[subtotal]
  Else
    Total = Subtotal
  End If
End Sub


Jconde
0
 
TerryEllisCommented:
Try it like this  IIF([tax],[total]=(1.07*[subtotal]),[total]=[subtotal])
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

IIf([tax],(1.07*[subtotal]),[subtotal])
0
 
toys032498Commented:
Great peace of code Tuvi and TerryEllis, I forgot all about IIF, thanks for the reminder.
0
 
TerryEllisCommented:
tuvi, your right on about not needing the "[total] = part". Thank you for the correction.
0
 
jrhinelyAuthor Commented:
Thanks, guys.  I wish I could award all of you some points.  Actually "tuvi" had what I used.
0
 
jcondeCommented:
Guess tuvi deserves the points uhhh!

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

Later
Jorge
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now