Percentage from Check boxes?

[Windsor302]

Hey there, I am trying to make a query that utilizes check boxes. My code looks like this:


SELECT DISTINCT [TRO SCOPE 3].Weld_No, [TRO SCOPE 3].VT_No, [TRO SCOPE 3].VT_Accept, [TRO SCOPE 3].VT_Reject, [TRO SCOPE 3].VT_Repair
FROM [TRO SCOPE 3];

VT_Accept, Reject and Repair are all check boxes, The purpose of the query is to determine the failure rate. Is there a way to count these 3 "when true" in the same query? Please let me know if you dont understand what I am trying to say.

Thanks.