IIF Statements

M

mb

New to access, very familiar with Excel.

I am trying to establish an if-then statement within a query to test for
multiple variables (similar to an embedded if-then statement in Excel).
From what I have found, the IIF Syntax will only perform one test (with the
possibility of and/or combinations).

Is there another function I can use for this process?

Thanks,
MB
 
S

SteveS

Depending on how complex your If..Then statement is, you can use nested
IIF()'s, or maybe the SWITCH() function. You can also write a custom function
and use it in the query.

If you provide an example of the If..Then statement, it would help answering
your question. :)

Steve S.
 
Top