OK using the IIF function in an equation it doesn't allow you to use the = symbol. I found a half @$$ way around this. If you create your equation with IS instead of = then when you hit OK it will drop you to the VB editor and ask if you want to debug. You say Debug and change the IS to = then it bongs again and you see it is back to IS change it back again. Now SW continues as usual but the equation seems to work. The thing that sucks is it always errors out when you rebuild. Darn another perfectly good solution goes to waste. Corey