Solved

MS Access Iff statement

Posted on 2013-05-27
2
393 Views
Last Modified: 2013-05-27
Hello,

I'm trying to add the following to an unbound text box on a report, but I'm getting the error:

"The expression you entered contains invalid syntax. You may have entered an operand without an operator."


=iif([tprPractitioner]="Person 1","2644004F", iif([trpPratitioner]=
Person 2","3573683H",""))

Can you see what I'm doing wrong?

Thanks
0
Comment
Question by:dabug80
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39198642
before Person 2 you have no quotes:
=iif([tprPractitioner]="Person 1","2644004F", iif([trpPratitioner]="Person 2","3573683H",""))

Open in new window

0
 
LVL 1

Author Closing Comment

by:dabug80
ID: 39198657
How silly of me. I couldn't see this. Thanks
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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 …

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now