Calculatations

[titch89]

i am doing a Q+A db which has a question table and then an answer table which are the correct answers. I used a query so all the answers come up but i dont no how to calculate how many they got right. i will either haev a field which has yes/no or just one that is marks which will come up either 1 for correct or 0 for wrong. Pls can some1 help to either write some simple code or something and say where to put it

Thanks in advance

 

[boblarson]

A yes in a yes/no field returns -1 not 1. A no is 0. To count how many -1's you have you can create a separate query that, if you just return the id that identifies who took the Q&A, and the yes (that they got it correct), you can use the grouping button (has the greek SIGMA letter - Σ on it) and the for the yes/no field, select COUNT instead of GROUP.