Multiple or nested IIF condition

[varadha72]

Hi Folks I need some help here.

IIf( Price.[FileName] ="Price" and [SubmissionType]="Add", "467",
IIf( Price.[FileName] ="Price" and [SubmissionType]="Change", "467",
IIf( Price.[FileName] ="Rate" and [SubmissionType]="Add", "209",
IIf( Price.[FileName] ="Rate" and [SubmissionType]="Change", "TA","")))) AS TACheck_label

This query is throwing error. Can someone help me here please.

 

[randy700]

Could it be something as simple as an extra SPACE?

IIf([[highlight #FCE94F] [/highlight]Price

Randy

 

[dhookom]

I abhor nested IIf()s. These values and numbers should be stored in a table where your data belongs. However consider using Switch()

Switch(Price.[FileName] ="Price" and [SubmissionType]="Add", "467", 
  Price.[FileName] ="Price" and [SubmissionType]="Change", "467",
  Price.[FileName] ="Rate" and [SubmissionType]="Add", "209",
  Price.[FileName] ="Rate" and [SubmissionType]="Change", "TA",
  True, "")

Do you really want to return a string from the expression?

Duane
Hook'D on Access
MS Access MVP