Gustav Brock
Gustav at cactus.dk
Sat Feb 11 07:08:34 CST 2006
Hi Dan and Charlotte OK, I just read your previous messages as suggestions for a final suggestion. /gustav >>> dwaters at usinternet.com 10-02-2006 21:59:19 >>> Gustav, Null was one of many possibilities, but needed to be handled uniquely. A second possible value needed to be handled a certain way. And then everything else (and they weren't null), all needed to be handled the same way. I ended up using: If IsNull(xx) Then ElseIf Else End If Dan PS - I guess I said Answered too soon!