Weird Query Possibility


J

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
 
Ad

Advertisements

K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top