a calculating expression in an Access form

[tnissley]

I have an Access form which is based upon a query. the form has students name and a checkbox next to each name. The checkbox is based upon the query and the default is no. When I check the box next to a student's name, I want to be able to count the number of Checkboxes in each column. I've used the formula =Count (Iif([Attendance]="yes",1,0)). When I do that I get an error message. What am I doing wrong. Attendance is the field created in the table as a checkbox.

 

[ScotB]

Hi, I'm a bit new to this myself, but since no one has responded yet, you could give this a try.

In the query you made for the form, type Present:IIf([Attendance],1) in the field box in a new column and run the query. You should see a new field named Present.

Open your form in design view and add a text box.
In the properties for the text box, type =Count([Present]) in the control source.

Hope this helps.

Gordon.