Acc 2000: Crosstab or Subreport question

[John Wilson]

Hello,

I have a table that gathers question responses (1-10) from a web form.
I need to get the number of correct responses per username. What's
tripping me up is I'm not sure how to separate the correct responses
from the incorrect responses in the same query. I created a subquery
for each question response and user, but when I try to put those
subqueries in a main query (to get all the correct responses), I get
repeating records and my recordset goes into the thousands (I'm
testing with less than 10 records).

So, do I need a crosstab query for this? And if so, how would I put
this together. I thought I might be able to just put criteria in the
where clause of my query and I was able to put together a report for
users who got all questions correct by putting the correct "values" in
the qbe grid. But, what if the user has some correct and some
incorrect (which is most likely).

I need to be able to return all correct responses for all users and
then get a count for all those responses so they can see who got the
most correct responses.

Should I do this in subreports? I'm just not sure how to approach
this. Any help would be really appreciated.

Thanks in advance,
John