Totals in MS Access 2003 Reports

[cynthia]

I need to the following types of totals for a report and hours of
trying different ways are not working:

I want to report totals for:

-Count of number of dates in a field (some empty fields) as well as
-Count in field containing numbers but only want to count # of
populated fields
-Count of Yes in Yes/No fields

Is there a way to total for absolute value?

Thanks.

 

[cynthia]

By doing a search here, I found the answer to the Y/N sum question.
Worked like a charm! Still looking for the others!

I need to the following types of totals for a report and hours of

 

[cynthia]

I have resolved all these issues. Once I found out how to sum Y/N
checkboxes, the others seem to fall into place. I even figured out how
to make a field total in absolute values. If you want to know, write
me!