MS Access Iff statement

Posted on 2013-05-27
Medium Priority
Last Modified: 2013-05-27

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?

Question by:dabug80
LVL 41

Accepted Solution

als315 earned 2000 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


Author Closing Comment

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

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

627 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