counting fields

[Dona]

Hi,

I need help. I want to count all the fields on a record that have a value.
I do not want to count the fields with a null value. I want to add up all the NonNull fields on a single record in one column.

Any ideas?

Thank you.

 

[KenHigg]

How many fields are there?

 

[Dona]

Three fields

 

[KenHigg]

Then would something like the following work:

(iif(fldOne & "" = "", 0,1)) + (iif(fldTwo & "" = "", 0,1)) + (iif(fldThree & "" = "", 0,1))

???
(Not pretty but should work )

 

[Dona]

Thank you very much.
It worked!

 

[KenHigg]

Cool - Glad to help