Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
IIF Problem (syntax?)
Profit: IIf ([ExtendedCost]) = 0, ([Retail for one Cost]) - ([SingleCost]), IIf (IsNull([SingleCost]), ([Retail for Multiple Costs]) - ([ExtendedCost])) ok so I changed it to this. The error that I'm getting is that I have the wrong number of arguments. joëlle- joellita
- Post #3
- Forum: Microsoft: Access Reports
-
IIF Problem (syntax?)
Ok so this is the part I've done: Profit: IIf ([ExtendedCost]) =0, ([Retail for one Cost]) - ([SingleCost]), IIf ([SingleCost])=Null,([Retail for Multiple Costs]) - ([ExtendedCost])) This is an access query.. Basically I want it to say that if the ExtendedCost value is 0 then do: retail for...- joellita
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
