Translating Excel IIF statement into Excel
Posted on 2004-11-14
I'm having some trouble turning a nested IF statement from Excel into an Access nested IIF query.
Here's the statement in Excel:
Fact_States ---Named range of a column of about 20 state codes. My biggest problem is checking to see if column I6 is in Fact_States. I tried making a table of state codes with the IN statement but couldn't figure out a statement similar to vlookup. I thought this would work:
FACT:IIF(State.Apps NOT IN States.tblFactStates, " ", (IIF(...
But the bigger problem is that I don't think I'm translating the if statement properly. Any help would be GREATLY appreciated.