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:

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?