Hi
I have a Boolean field about attendance (Yes/No) I want to calculate the number of attendance (Yes) in query for every student.
ID Name W1 W2 W3 1 John Yes No Yes 2 George No No Yes
Hi
I have a Boolean field about attendance (Yes/No) I want to calculate the number of attendance (Yes) in query for every student.
ID Name W1 W2 W3 1 John Yes No Yes 2 George No No Yes
Run 3 count queries, then a union query to sum those.
but,your table is designed wrong, it should be:
ID, W, Wval
2, w1,no
2,w3,yes
So you can count anything.