EASY Access 97 Count Question - TechRepublic
General discussion
February 12, 2003 at 12:12 AM
mra2

EASY Access 97 Count Question

by mra2 . Updated 23 years, 1 month ago

I have a table with 2 fields. Name (Text) and Present (Yes/No Checkbox). There are 6 records, three are checked.

I made a report with both fields and was able to get a count of all names (6).
Now I want to count only the check boxes. I made a calculated field called checked and put =(IFF([Present] = “-1” , 1, 0))
I put this field in the detail section.

NOW, in the report Footer, I want to Count all the “checked” records. I keep getting a Parameter box for the checked field.

What am I doing wrong???

Thanks,
Alan

This discussion is locked

All Comments