View Single Post
 
Old September 30th, 2005, 11:08 AM
Corey Corey is offline
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default Nested Query with an iif statment

Hello again,

I currently have a formula that looks like this: Qty:
Sum(IIf([OL_PRICE]*([OL_QTY_ORD]-[OL_QTY_CAN_TD])=0,0,([OL_QTY_ORD]-[OL_QTY_CAN_TD])))

I have another field titled: Description: P_DESC

I would like to add to the Qty formula that if the letters “*SS*” located it the P_DESC then /2

Can anyone help me learn how to combing two iif statements?

Thanks

Corey