Showing a gird of data produces a row of the same values?

[jkonline2]

I am creating a questionnaire database where the user can pick between 5 options in each question. The values in the database are stored as a number in a single field betwen 1 and 5 with the question number in another field.

I wish the output to count how many of each result thre has been as below:


Question No. Op1 Op2 Op3 Op4 Op5
1 2 1 1 2 0
2 3 0 0 0 3
3 0 0 0 0 0
4 1 0 2 0 2
5 1 2 0 1 8

However currently with a crosstab query i am getting the count of the option one placed in the box for every question as below:

Question No. Op1 Op2 Op3 Op4 Op5
1 7 3 3 3 13
2 7 3 3 3 13
3 7 3 3 3 13
4 7 3 3 3 13
5 7 3 3 3 13

I have other types of queries e.g. grouping and it does not work. Can anyone help?

 

[jkonline2]

Fixed. Opps Just needed to change the link between tables