IIF Statements

[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

 

[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.

 

[mb]

Disregard - found my issue (helps to use the correct syntax). Thanks for
your help.