Count/Sum value in a textbox

[brandonze]

How do I display count/sum values in a textbox on a form?



this is what I am doing and it is not working

=Count([EmployeeRegistered])

I have aslo tried

=Count([QueryName]![EmployeeRegistered])

I have tried boud to the query and unbound. No luck. I know I am missing something simple.

Help Please?

[brandonze]

I fgured out the sum part of the problem, But now I am using the count function on a Yes/No check box and it is returning all of the records instead of only the number of checked records.

im using

=Count([EmployeeRegistered])

Any thoughts?

[rpeare]

=abs(sum([EmployeeRegistered]))

takes the absolute value (removes a negative sign from a -1 (or positive) value of a yes/no field