I have a report that is filtered based on age, sex, and race. I have 41 yes/no fields for cable channels. I need to be able to show totals for which channels are watched based on the selected criteria. For example, I need to know how many white females under 18 a particular channel.
Counting Yes/No's within filtered report
- Thread starter LostBall
- Start date
RichO
Registered Yoozer
- Local time
- Today, 07:39
- Joined
- Jan 14, 2004
- Messages
- 1,036
So you have 41 yes/no fields per record?
If you are showing these results in a report you can show the total of a particular field in the report footer.
Because yes/no fields return a 0 or -1 you could sum the absolute value.
=Sum(Abs(MyField))
If you are showing these results in a report you can show the total of a particular field in the report footer.
Because yes/no fields return a 0 or -1 you could sum the absolute value.
=Sum(Abs(MyField))
