Access Query Question -- Do Not Know Where to Start 1

[henchcliffe]

Hi.
I have a table that looks something like this:

NAME Date question1 question2 question3
bob 1/1/1 1 0 1
bill 2/2/2 0 1 0

The numbers correspond to whether a question was answered correctly or not (1 is right 0 is wrong)the table I am working with has 30 questions.
Is there a simple way to query this information so that it comes out looking like this:

NAME DATE question
bob 1/1/1 question2
bill 2/2/2 question1
bill 2/2/2 question3

In essence I want to write a query that only shows the results if a question is scored a 0 and what that question was.

THANKS in ADVANCE.

 

[Craig0201]

Eeek....

Sounds like you've got a messy table....

So.....

The EASIEST way (in my opinion) to do this isn't use a query at all but a recordset and parse that into a new table........

For a similar thread in which I answered this, see thread181-192373

Craig

 

[henchcliffe]

With a little adjustments your solution worked fine.
THANKS FOR YOUR PROMPT HELP!!


CMH