You've got the right attitude!
Are your check box fields set up with both a box for yes and a box for no?
Ah ! I just realised I set the checkbox for a Yes box only. (There is no "No" box in this layout)
Therefore the count of each set of records in that field would be based on a value of 1?
A single check box is better than two in this case as Yes = not empty while No = empty.
Count won't work in this context. If the Yes check box is selected, Count ( CheckBoxField ) simply yields 1, meaning that the field in the current record is not empty.
To get a count across a found set of records define a "count of" summary field.
Note that many developers use a single value value list of just the number 1 for such uses of the check box. You size the field small enough that the 1 is not visible and you add layout text for a label. Such a field can be counted or summed to get the number of records where the check box is selected.
But you have other issues to resolve in your design.
I would imaging that each different surgical procedure requires a different check list. If so, you should consider using two tables in a one to many relationship:
Procedures::__pkProcedureID = CheckListItems::_fkProcedureID
This allows you to build a different set of check list items for each different procedure.
You might research "Questionnaire" or "survey" here in the forum to find some discussions that of solutions that would also apply to check lists.
Actually there are only two procedures that I am having to enter, and only one of those requires a breakdown
So... I have one field which is scope type - dropdown box for choice of which
Then I have also on the Scope Table fields for each type of polyp found - that is what requires the counts and to be graphed.
eg. I have fields : Polyp Type A, Polyp Type B, Polyp Type C etc . The fields each have the Yes checkbox, so I can count them to get total number of records for each field.
It is these totals that I want to be able to graph - just not sure how as from what I have seen in the basic tutorials I can only select a single data source
Are the types exclusive? Can the same polyp be more than one type?
One scope can produce several polyps and each polyp can have more than one type
That's why I set up individual fields for the polyps - was this the wrong way to do so?
I would definitely set up one record for each polyp in a related table linked to your procedure record. Then it doesn't matter how many or how few polyps to a procedure--that becomes just a matter of how many records you create and link to the same procedure record.