iif statement within query

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

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
 
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.
 
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
 
Back
Top