How to use Rnd to order records?

[Gdm]

I've tried unsuccessfully to get Access to order records based on a field in a query that uses Rnd() function.

Here is an example of my unsuccessful attempt:

SELECT * FROM (SELECT field1, field2, Rnd(field3+Time()) * 1000 + 1 AS DspField3Order, field4 AS TempSelect)


TempSelect ORDER BY DspField3Order

I get pseudo-random numbers for DspField3Order on each record, but Acces does not order by them.
Is there a way to make this work?

Thank you.

Gdm.

[Gdm]

I found a solution. Do not include the Rnd() in the SELECT statement, only in the ORDER BY.