iif statement within query

[alecgreen]

Hi

From the result of an iif query, is it possible to change the value of
a another field, other than the field with the iif query?

Many Thanks

Alec

 

[Ken Snell]

Tell us in words what you are wanting to achieve, and then we can answer
your question. Your posted question is not detailed enough to provide an
answer.

 

[Tom van Stiphout]

On Tue, 8 Jun 2010 11:18:07 -0700 (PDT), alecgreen

Perhaps it would be simpler to have a helper table, which for each
combination of PartNo and Description shows which Finish to use.

Or perhaps a VBA function to return the Finish based on PartNo and
Description passed in.

-Tom.
Microsoft Access MVP