Count tick boxes in subform

[Tanya]

Hi
I have a subform with several fields containing tick boxes and I need to
count the number of ticks for each field. I understand I need a txt box for
each total.

Begining with one field [Book] I have the following expression in txtBookTotal

=abs([Count]*[Book])

but this is not returning the answer I am expecting perhaps I should be
using the sum or IIF function. If anyone has a solution I would be very
greatful.
Kind regards
Tanya

 

[John W. Vinson]

Hi
I have a subform with several fields containing tick boxes and I need to
count the number of ticks for each field. I understand I need a txt box for
each total.

Begining with one field [Book] I have the following expression in txtBookTotal

=abs([Count]*[Book])

but this is not returning the answer I am expecting perhaps I should be
using the sum or IIF function. If anyone has a solution I would be very
greatful.
Kind regards
Tanya

Could you give us a bit of help here? We can't see your form! Is [Count] a
field in your table? (If so, it's badly named: Count is a reserved word used
in Totals queries and should not be used as a fieldname). Is [Book] a Yes/No
field? Where do you have this expression - on the subform's detail section, or
the subform Footer?

What is the Recordsource for your subform, and just what do you want summed?

 

[Tanya]

Hi John
For some reason I am unable to view your response. I have tried a number of
times throughout the day.
cheers
Tanya