simplify IIf

[jlute]

Can this be simplified?

UNEstNtWt: IIf([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+[UNNtWt],
6),IIf([tblFGUOM].[UOMType]="VOL",Round([UNNtWt],6)))

Thanks in advance!!!

 

[Douglas J. Steele]

What's your definition of "simplified"?

The only way I can think of would be:

UNEstNtWt:
Switch([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+[UNNtWt],6),[tblFGUOM].[UOMType]="VOL",Round([UNNtWt],6))

 

[jlute]

Thanks, Doug! That's simplified in my book

Thanks!

What's your definition of "simplified"?

The only way I can think of would be:

UNEstNtWt:
Switch([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+[UNNtWt],6),[tblFGUOM]­.[UOMType]="VOL",Round([UNNtWt],6))

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Can this be simplified?

UNEstNtWt: IIf([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+[UNNtWt],
6),IIf([tblFGUOM].[UOMType]="VOL",Round([UNNtWt],6)))

Thanks in advance!!!- Hide quoted text -

- Show quoted text -