simplify IIf

  • Thread starter Thread starter jlute
  • Start date Start date
J

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!!!
 
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))
 
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?
Click to expand...
UNEstNtWt: IIf([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+[UNNtWt],
6),IIf([tblFGUOM].[UOMType]="VOL",Round([UNNtWt],6)))
Click to expand...
Thanks in advance!!!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top