Returning multiple columns from one table??

[mundo7]

Hi all, i have a table like this:

SUPPLIER QUESTIONUMBER ANSWER
supp1 1 answer 1
supp1 2 answer 2
supp1 3 answer 3
supp2 1 answer 1
supp2 2 answer 2
supp2 3 answer 3
supp3 1 answer 1
supp3 2 answer 2
supp3 3 answer 3

what i want is a query to come up with something like this:

SUPPLIER QUESTION 2 QUESTION 8
supp1 answer 2 answer 8
supp2 answer 2 answer 8
etc.

I cannot get my head around ti even though i know it's probabyl really simple (i'm not that clued up really!)

Can anyone help or point me in the right direction?

 

[Dumbfounded]

hi Mundo,

Is this like a pointing system for the answers to questions, i.e. if supp1 chooses answer 2 to question 2 he gets 8 points? or am I missing the point?

Donna.

 

[khawar]

you can use a crosstab query

 

[mundo7]

Yes it is sort of a pointing system for scoring answers to question, however i have very little knowledge of using cross-tab queries etc.

I will have a play around with a cross tab query now, however if someone could give me some advice that would be superb.

Thanks

 

[khawar]

Download the attached sample and check the query