Alternating Query

[peterh]

Hello,

Is it possible to create a query that will show results from a database in alternating order of one field?

I am trying to get the following result:

http://www.lease2.co.uk/tables.jpg

Many thanks!

[chazzy]

what's the logic behind that order? if it's just random i dont think so.