If you have a query with several fields, and some of these fields contain values and some do not, how do you get a sum of "non-zero" values.
For example let's say you have a query with numerous fields that may or may not contain numbers. Now you want to know for each record the total number of fields that contain values.
How do you write the expression?
For example let's say you have a query with numerous fields that may or may not contain numbers. Now you want to know for each record the total number of fields that contain values.
How do you write the expression?