Sort Row Headings for Crosstab Query

Hi



I have a created a crosstab query which gives me the results I need, but I want to sort the row headings differently. These are not numbers, but machine sizes which range from 4 Metre to 20 Metre. Currently, the crosstab gives me:



10 Metre

12 Metre

14 Metre

17 Metre

20 Metre

3 Metre

4 Metre

5 Metre etc



But I need to show it as:



3 Metre

4 Metre

5 Metre

10 Metre

12 Metre

14 Metre

17 Metre etc.



The field is short text data type and data comes from an ODBC linked table to SQL server table, and I am using Access 2013.



What is the best way to achieve this for my query?



Many thanks

Martyn

Sort Row Headings for Crosstab Query