Weird Query Possibility

[Jason Lopez]

I am looking to avoid having to use a bunch of nested IIf statements in the
query I am trying to design. Is there a way to somehow create a table to
which a query will use as the basis of an IIf statement? For example:

"Result: IIf (Condition1 = [Table1].[Factors], x, y)"

Where Table1 is an actual table to which the IIf statement would compare the
Condition1 field.

Is this possible without having to do code? And if it requires coding, how
would I set this up?

Jason Lopez

 

[KARL DEWEY]

Try it this way --
Result: IIf (Condition1 = [Table1].[Factors], [Table1].[X-Factor],
[Table1].[Y-Factor])