Query Sort AZ

[Ruegen]

Query sort AZ but have one particular Be first

so if ID 1,2,3,4,5 then sort 1 - 5 however

I want as 5,1,2,3,4

I want to be able to start ascend from 5th (it only goes up to 5) first then follow 1,2,3,4 after than

can it be done?

[June7]

There are only 5 records in the table?

Will have to calculate a field to apply sort order criteria. Like:

SELECT * FROM table ORDER BY Choose([ID], 2, 3, 4, 5, 1)

[CJ_London]

or use a union query to select the first item in the first component , then in the second component select all records except the first item and order

[June7]

Or another field in table to enter the order number.

[Ruegen]

Thanks heaps guys