I have created a select query where I calculate the % of pupils working at a certain level in each subject.
I now want to create a crosstab query with the level as a row heading and subject as a column heading and display the % of pupils but although it is formatted as % in the select query and displays correctly in does not display this way in the crosstab query
Level Art Drama
2 0.101639344262295 9.50819672131148E-02
3 8.85245901639344E-02 9.50819672131148E-02
Even though I got to properties and select format > percentage it does not seem to work.