count ticked check box

[linux44]

hi
i have table for attendance monitor and contaion following attribute:
session ID
Student Id
Attended session which is in yes/no format or in other work it give u option to tick it

date



and now what i want to do is that create a query and tell it to only count the number of attended session which has been ticked not count all the attended session for one student ,only count the ticked one
any idea please?
thanks

 

[Villarreal68]

Within the query under the Attend (Yes/No) field in the Criteria section enter Yes This should filter out the No records.

 

[Villarreal68]

Here is a screen shot.

 

[linux44]

many thanks for response but it wont work
does yes mean ticked?

 

[Villarreal68]

That is correct i just tested it and it works. Something else on the Query is probably being filtered already.

If you put NO in the Criteria it will only give you unchecked records. If you put YES in the Criteria it will only give you checked records. If you put nothing in the Criteria it will give you ALL records.

 

[Villarreal68]

One question: is the Date Field called Date? if it is you may want to change it. Date is a reserved word and it will cause you problems. Change it to AttendDate or something.

 

[Villarreal68]

Check out this example in Access 2000 format.

 

[linux44]

thanks a lot it works
thank you very much u saved me

 

[Villarreal68]

Glad i was able to help.