Solved

Using an "Or" Statment

Posted on 2009-05-05
3
219 Views
Last Modified: 2013-11-27
Source: IIf([Account]=15190 Or 5190,"CAP",(IIf([Account]=73090 0r 3090,"EXP","ERROR")))

I am not sure if I need to add more If statments, or if I am putting the 'or' in a werid spot???!?!?
0
Comment
Question by:SueMos
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Chuck Wood earned 500 total points
ID: 24306159
I think this is what you are trying for:

IIf(([Account]=15190 Or [Account]=5190),"CAP",IIf(([Account]=73090 0r [Account]=3090),"EXP","ERROR"))

Open in new window

0
 

Author Comment

by:SueMos
ID: 24306210
I knew it was some little thing!! Thanks!

Source: IIf(([Account]=15190 Or [Account]=5190),"CAP",IIf(([Account]=73090 Or [Account]=3090),"EXP","ERROR"))

Open in new window

0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24306223
You're welcome. Good luck with your project.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

773 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