Sorting a Crosstab query by the Values

[Carly]

I have a crosstab query which contains 1 lrow & 4 columns. The column headings are vendor numbers & the value is Sales.

I would like to sort the crosstab by the value rather that the column headings so that the greater value is at the start but it is automatically sorting the columns into Vendor Number order.

Can this be done?

Kind Regards

Carly