In Access SQL it is possible to call certain VB Functions directly. In this
case the Rnd function can be called in a query and fed a seed value from the
data being sorted. Here is an example to randomly sort some invoice
numbers:
SELECT xTstSource.InvoiceNo, Rnd([InvoiceNo]) AS RndOrder
FROM xTstSource
ORDER BY Rnd([InvoiceNo]);
xTstSource is just a test table I created for the purpose of this post.
I have used the method that John puts forward and also used this one. This
one is simpler to implement and now is the one I use almost exclusively. I
stumbled across this solution in this forum and so must admit I am standing
on someone else's shoulders here. Thanks to all who answer here.
--
Jeffrey R. Bailey
"Greg Brady" <vz******@verizon.net> wrote in message
news:U0*******************@nwrddc01.gnilink.net...
Is there a way to return a random sort order from a query?