Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

if...then

Posted on 1998-09-16
8
Medium Priority
?
411 Views
Last Modified: 2008-02-26
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
Comment
Question by:jrhinely
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Expert Comment

by:Willtry
ID: 1962567
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
 
LVL 7

Accepted Solution

by:
jconde earned 200 total points
ID: 1962568
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
 

Expert Comment

by:TerryEllis
ID: 1962569
Try it like this  IIF([tax],[total]=(1.07*[subtotal]),[total]=[subtotal])
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 5

Expert Comment

by:tuvi
ID: 1962570
You don't need the [total]= part. Try this:

IIf([tax],(1.07*[subtotal]),[subtotal])
0
 
LVL 1

Expert Comment

by:toys032498
ID: 1962571
Great peace of code Tuvi and TerryEllis, I forgot all about IIF, thanks for the reminder.
0
 

Expert Comment

by:TerryEllis
ID: 1962572
tuvi, your right on about not needing the "[total] = part". Thank you for the correction.
0
 

Author Comment

by:jrhinely
ID: 1962573
Thanks, guys.  I wish I could award all of you some points.  Actually "tuvi" had what I used.
0
 
LVL 7

Expert Comment

by:jconde
ID: 1962574
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question