Working With Check Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with four field, Frame (Number), L, C, & R (Check boxes).
Each record must have a Frame number and there can be duplicates. Also, all
or any combination of the three checkboxes can be checked. The report is
grouped by the frame number.

What I would like to achieve is to count the total number of records for
each frame number and also count the amount of true checkboxes for each
field. Then sum the totals for L, C & R.

Any help appreciated

Nick
 
hi Nick,

Nick said:
I have a report with four field, Frame (Number), L, C, & R (Check boxes).
Each record must have a Frame number and there can be duplicates. Also, all
or any combination of the three checkboxes can be checked. The report is
grouped by the frame number.
What I would like to achieve is to count the total number of records for
each frame number and also count the amount of true checkboxes for each
field. Then sum the totals for L, C & R.
Click to expand...
Use

=Sum([L])*(-1)

as ControlSource in a TextBox in your group footer.


mfG
--> stefan <--
 
Thanks Stefan

Regards
Nick

Stefan Hoffmann said:
hi Nick,

Nick said:
I have a report with four field, Frame (Number), L, C, & R (Check boxes).
Each record must have a Frame number and there can be duplicates. Also, all
or any combination of the three checkboxes can be checked. The report is
grouped by the frame number.
What I would like to achieve is to count the total number of records for
each frame number and also count the amount of true checkboxes for each
field. Then sum the totals for L, C & R.
Click to expand...
Use

=Sum([L])*(-1)

as ControlSource in a TextBox in your group footer.


mfG
--> stefan <--
Click to expand...
 
Back
Top