You can try an expression like:
=Sum(Abs( ([Mail] + [E-Mail]) = 0) )
A yes/no field evaluates to either true/-1 or false/0. This allows you to
compare with 0. The Abs() converts true/-1 to 1.
Expanding on your idea from a while back, this can be simplified to:
=Sum(1+([Mail] Or [E-Mail]))
Which only uses one function call.
Clifford Bass
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.