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.

 

[alecgreen]

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

        Ken Snellhttp://www.accessmvp.com/KDSnell/









- Show quoted text -

Here goes!, I hope I can explain this in more detail

I have three fields PartNo, Description, and Finish

Both the PartNo and Description have information regarding the Finish

So basically I want to query the PartNo and Description to determine
the Finish

There can be 3 or 4 options within both PartNo and Description to
determine the Finish

I have used a complex nested iif on PartNo which works, but want to do
this on Description, both in the same query to infulence Finish

Regards

Alec

 

[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