Counting fields

[nfregistrar]

I want to have a field in each record of a data base called num that is a count of how many of 20 text fields (F1 through F20)in that record contain data.

I could set up 20 more fields (N1 through N20), each of which is a calculation corresponding to one of the F1 through F20 fields which is 1 if the field is not empty and 0 if it is: for instance:N1=If (F1<>"",1,0) And then num could be a sum of N1 through N20.

Is there an easier way?

Dave

[Chuck]

Set Num to the following calculation:

( not IsEmpty( F1 ) ) + ( not IsEmpty( F2 ) ) + ( not IsEmpty( F3 ) ) + ... + ( not IsEmpty( F20 ) )

Each time the field isn't empty, the ( not IsEmpty( Fx ) ) will return a 1. If it is empty, it will return a 0. Adding them all together will give you a count of how many have information.

Chuck

[nfregistrar]

quote:

---

Originally posted by Chuck:

Set Num to the following calculation:

( not IsEmpty( F1 ) ) + ( not IsEmpty( F2 ) ) + ( not IsEmpty( F3 ) ) + ... + ( not IsEmpty( F20 ) )

Each time the field isn't empty, the ( not IsEmpty( Fx ) ) will return a 1. If it is empty, it will return a 0. Adding them all together will give you a count of how many have information.

Chuck

---

Thanks Chuck, That did it.

Dave