Can I use an "If" statement in the critera of my query?

[Jimenda]

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another column? Is this fesible? How do I do it?

Thanks
Jim

 

[jsteph]

Use the IIF (Inline IF) function. Alternatively, always remember that you can use any function in a query and pass it fields and do any logic you want.

In the Field row, just put:
MyAliasColumnName: SomeFunction([somefield1],[somefield2],[somefieldn])

The function obviously must have the correct number & type of arguments.

The IIF goes like:
IIF(Some Expression,value if true,value if false)

--Jim