|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
November 1st, 2004, 06:02 AM
|
|||
|
|||
|
counting choice fields in a report
I have a report, where some features are listed as checkboxes. I'd like to have all checked checkboxes counted at the end of report. I've created text field. What shuold be the command in it ? (to count only checked boxes).
Thanx for any help
|
|
#2
November 1st, 2004, 11:45 AM
|
|||
|
|||
|
Place this as the control source for your unbound text field
=Sum(IIf([Yes/No]=-1,1,0)) Just change the Yes/No above to the name of your checkbox lwells
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > counting choice fields in a report |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
