Query to check response to questions

I don't know how best to describe this, except with an example of what i
want to do:

A table in MS Access 2000 holds choices made by a user in response to a
series of questions, but for each question in the response (a response
equates to a record) there is a rule that if she chooses (a or b) for
any question in that response, then she can't choose anything else for
that response.

So, for response 1, there are 6 questions each having 5 options. From
the 5 options, she can choose from a,b,c,d, and e. She can select an
option from more than one question, unless she chooses a or b in any of
them, in which case that's the only question she can respond to.

Basically you can imagine it by thinking of a form, showing multiple
rows. For each row, there are 6 combo boxes with the 5 choices. The user
may choose anything she likes in a row unless in any of the combos she
chooses a or b, in this case that is all she shall be allowed to select
for that row, the rest must remain empty.

The tables look like this:

[table] Responses
id (PK)
Q1
Q2
Q3
Q4
Q5
Q6

[table] Choices
id (PK)
choice


I've tried using a SQL query but I'm not having much luck, would anyone
have a suggestion?!

Thanks in advance!
Ben

Re: Query to check response to questions

ben h wrote:
> I don't know how best to describe this, except with an example of what i
> want to do:
>
> A table in MS Access 2000 holds choices made by a user in response to a
> series of questions, but for each question in the response (a response
> equates to a record) there is a rule that if she chooses (a or b) for
> any question in that response, then she can't choose anything else for
> that response.
>
> So, for response 1, there are 6 questions each having 5 options. From
> the 5 options, she can choose from a,b,c,d, and e. She can select an
> option from more than one question, unless she chooses a or b in any of
> them, in which case that's the only question she can respond to.
>
> Basically you can imagine it by thinking of a form, showing multiple
> rows. For each row, there are 6 combo boxes with the 5 choices. The user
> may choose anything she likes in a row unless in any of the combos she
> chooses a or b, in this case that is all she shall be allowed to select
> for that row, the rest must remain empty.
>
> The tables look like this:
>
> [table] Responses
> id (PK)
> Q1
> Q2
> Q3
> Q4
> Q5
> Q6
>
> [table] Choices
> id (PK)
> choice
>
>
> I've tried using a SQL query but I'm not having much luck, would anyone
> have a suggestion?!
>

A suggestion for what? What exactly is it that you want to do?
Prevent someone selecting more options after they have selected a or b?
That's probably best dealt with in a clientside group. Or is it
something else?

--
Mike Brind

Re: Query to check response to questions

Mike Brind wrote:
>
> Prevent someone selecting more options after they have selected a or b?

Yes, exactly.
I've been working out in detail what I'm trying to explain here and
discovered in the meantime a way to do it.
Thanks
Ben