MS Access IIF Statement

15 pts.
Tags:
IIF function
Microsoft Access
I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be deducted from your Social Security check. After this, your new premium amount will also be deducted from your monthly Social Security check."), ([lepamtpaid]=3, “[Employer Group Name] & " has agreed to pay " & [Part D Late Enrollment Append Amt] & ", the amount of your late enrollment penalty, on your behalf. If your coverage is terminated by you or " & [Employer Group Name] & ", or if " & [Employer Group Name] & " stops paying your late enrollment penalty, you will be responsible for paying that amount.")
ASKED: October 8, 2008  2:49 PM
UPDATED: October 10, 2008  2:24 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You need iif statements in the false section of each of the previous iif statement. Try this:

=IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.”,<b>IIf</b>(lepamtpaid = 2, “This lump sum amount will be deducted from your Social Security check. After this, your new premium amount will also be deducted from your monthly Social Security check.”,<b>IIf</b>([lepamtpaid]=3, “[Employer Group Name] & ” has agreed to pay ” & [Part D Late Enrollment Append Amt] & “, the amount of your late enrollment penalty, on your behalf. If your coverage is terminated by you or ” & [Employer Group Name] & “, or if ” & [Employer Group Name] & ” stops paying your late enrollment penalty, you will be responsible for paying that amount.”) <b>))</b>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jsweitzer
    Thank you for your assistance. I have added the IIf statements in the "false"section of the statements. However, I also discovered that since I am pulling information from a query I had to add a Second " (double quote) before ""& [Employer Group Name on the Iif statement for Option 3. Works now, thank you so much.
    15 pointsBadges:
    report
  • Dwaltr
    Glad to help. -Dave
    900 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following