>That worked! Thanks. I hadn't thought of the value possibly being all zeros. What's the best way to trap for that?
Do you really need to trap for that? If it is invalid, there will be no matching records and your isnull call will do the same as the if will do, right?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges