Total of all TRUE fields in query

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

In my query I have 4 true/false fields. Now i want to create an addional
field that shows all the true value of the 4 selected fields. For example
total records =50, field 1 has 10 TRUe values, field 2 has 5 TRUE values,
field 3 has 15 True values and field 4 has 10 True values. The addional
field must show all TRUE fields How to do?
 
In my query I have 4 true/false fields. Now i want to create an addional
field that shows all the true value of the 4 selected fields. For example
total records =50, field 1 has 10 TRUe values, field 2 has 5 TRUE values,
field 3 has 15 True values and field 4 has 10 True values. The addional
field must show all TRUE fields How to do?
Click to expand...


I'm not sure I understand. Let's start with a five-row example:

Field1 Field2 Field3 Field4
True False False False
False True False False
Flase False True False
False False False True
False False False False

What do you want the new field to show in these five cases? The
*number* of true or false fields really has nothing to do with how
they are related to one another!
 
Back
Top