IIF "and" statement

[slotmgr70]

I'm trying to create a simple IIF state ment that looks at two seperate
fields and returns a code. For example:

IIF [revenue]>=500 AND [territory]="Inner Market", "BD_500IN", "BD_500"

I know this isn't right because I tried it a bunch of different ways and
keep getting errors. What is the correct IIF statement for using two
arguments?

 

[Jeff Boyce]

It might help us diagnose what's happening if you'd tell us what's happening
(i.e., the error messages).

Is there any chance that your [territory] field is defined in its table as a
"lookup" datatype?

Have you tried including [revenue] and [territory] as fields in your query
to see what is actually in those fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Did you try it like this ---
IIF([revenue]>=500 AND [territory]="Inner Market", "BD_500IN", "BD_500")