Access Formulas

[bwlytkr]

Am I able to write a formula to capture info from another formula in the same query. For ex. The top formula gives me the data and the bottom formula is what I want to produce a result based on the to formula.

AT&T Status: IIf(Left([MSLA NTG]![JobIdentifier],3)="PWO","PWO",IIf(Left([MSLA NTG]![JobIdentifier],3)="DIS","NEED SURVEY",IIf(Left([MSLA NTG]![JobIdentifier],5)="Issue","REF TO ENG",IIf(Left([MSLA NTG]![JobIdentifier],4)="PRTP","REF TO ENG",IIf(Left([MSLA NTG]![JobIdentifier],2)="RW","RW REQUIRED",IIf(Left([MSLA NTG]![JobIdentifier],3)="DIS","DISPUTE",IIf(Left([MSLA NTG]![JobIdentifier],4)="CONST","CONST REVISIT",IIf(Left([MSLA NTG]![JobIdentifier],4)="DROP","DROP ONLY",IIf(Left([MSLA NTG]![JobIdentifier],3)="ENG","REF TO ENG",IIf(Left([MSLA NTG]![JobIdentifier],3)="Ref","REF TO ENG",IIf(Left([MSLA NTG]![JobIdentifier],3)="Reo","NEED SURVEY",IIf(Right([MSLA NTG]![JobIdentifier],1)="n" Or Right([MSLA NTG]![JobIdentifier],1)="d" Or Right([MSLA NTG]![JobIdentifier],1)="b" Or Right([MSLA NTG]![JobIdentifier],1)="a" Or Right([MSLA NTG]![JobIdentifier],1)="c","EWO","Need Survey"))))))))))))

This produces a result of PWO, Needs Survey, REF TO ENG, etc..


Responsible Party: IIf(Left([MSLA NTG]![AT&T Status],3)="PWO","Construction",IIf(Left([MSLA NTG]![AT&T Status],3)="EWO","Construction",IIf(Left([MSLA NTG]![AT&T Status],2)="rw","Construction",IIf(Left([MSLA NTG]![AT&T Status],4)="Need","SourceOne",IIf(Left([MSLA NTG]![AT&T Status],3)="AFO","AFO"))))))))

This is what I wrote to capture the top result and produce Construction, SourceOne, AFO, etc. However, I get a parameter value message each time I try this.

Any help would be appreciated. Thanks John

 

[bwlytkr]

nevermind, i figured out my issue. the mlsa ntg does not appear in the top formula box. dummy me!!