Need help with Expression

[Lori2836 via AccessMonster.com]

I have a query where I'm trying to force a rank (Rank 39) to change to (Rank
70) if the Planner Code is either A, B, C, D or E. Can someone help me? I
know my expression isn't right.


SFR Rank: IIf([SFR Rank]=39, IIf([DIM - Local]![Planner Code]="A", "B", "C",
"D", "E", [SFR Rank]=70)

Thanks,
Lori

 

[Marshall Barton]

I have a query where I'm trying to force a rank (Rank 39) to change to (Rank
70) if the Planner Code is either A, B, C, D or E. Can someone help me? I
know my expression isn't right.


SFR Rank: IIf([SFR Rank]=39, IIf([DIM - Local]![Planner Code]="A", "B", "C",
"D", "E", [SFR Rank]=70)

I think this will do that:

SFR Rank: IIf([SFR Rank]=39 AND Local]![Planner Code]
IN("A", "B", "C", "D", "E"), 70, [SFR Rank])

but I'm not sure about naming the calculated field the same
as a field in the table.