Count on a report not working

[lr999]

Hello

I've got to count a Verified field (yes/no) on a report which have a Funcmodule footer and a Report Footer. I need #Verified and
%Verified ; So my code =Count([Verified]) and =Count[Verified])/([Verified Grand TotalCount])
on both footers. It's not working and I can't figure out why.? Verified field comes from a form and has a check or no check in the box.

 

[sxschech]

If verified is coming directly from the form, you need to point to the form something like:

=Count([Forms]![FormName]![Verified])

 

[Gammachaser]

You also forgot an open parenthesis:

=Count[Verified])/([Verified Grand TotalCount])

Should be:

=Count[b]([/b][Verified])/([Verified Grand TotalCount])

We need more information to figure out if those are the only problems.

 

[dhookom]

Count will count all non-null values. A yes/no field might store -1 or 0 which will both be counted.

If you want to count the Yes values, use something like:

=Sum(Abs([YourYesNoFieldNameHere]))

Duane
Hook'D on Access
MS Access MVP