Count Fields in Access Query

[zakaria]

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

[ranman256]

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.