counting only checked boxes

  • Thread starter Thread starter jackie payne
  • Start date Start date
J

jackie payne

i am a new user for access and am trying to accomplish 2
final tasks for an access application:

1. add a count feature on a report that will only count
the "yes" value of a check box. right now the count
feature is counting everything.

2. create a macro that will check the entered data of a
form object and compare it to a list of items in a table.
if the entered data matches, then i want access to enter a
check in the next field. i have played around with the
isnull, dlookup and iif functions but can not seem to get
it to work correctly. i do not know visual basic and am
solely relying on the expression builder. i know the
basic process would look like:

if (form object name) is listed on table, then check (next
form object)

if (form object name) is not listed on table, then leave
check box no.

i also need help in determining do i place this macro on
the before update or after update event or both!!!
 
To count the number of YES check boxes:
=Abs(Sum([CheckBoxFieldName]))

To count the number of NO check boxes:
=Sum([CheckBoxFieldName] +1)
 
Back
Top