I've solved this now by creating a query from the SQL, updating the query to include the sort and then viewing it as SQL and copying it. The SQL script included a ORDER BY clause at the end which sorts the records.
I am still having problems though trying to right align numeric fields in a list box selection. Any ideas ?
eg the data is coming back like
Horse Racing £100,000.00
Football £5,000.00
As opposed to
Horse Racing £100,000.00
Football £5,000.00
Thanks Thanks
Jamie