Stopping a crosstab query sort fields alphabetically

[swills]

HI all,
In my database i have a crosstab query that has a text field as a row heading and a number field as a column heading. The query is sorting the row heading on the left hand side alphabetically. I dont want it to do this, i want it to show the fields as they are in the table.

Is there anyway of stopping the query automatically sorting alphabetically?

Thanks in advance

 

[alastair69]

is there anything in the sort field within the query design mode

 

[swills]

no, at the moment the sort fields are empty

cheers