[AccessD] A2003: Random order

Steve Erbach erbachs at gmail.com
Wed Oct 26 13:54:43 CDT 2005


Whoa! Now THAT'S what I was looking for! Except I can't find anything in
Access VB help on Checksum() nor NewID(). Am I missing something? I found
ONE reference to NEWID() in the Access help and ONE for Checksum().

Steve Erbach

On 10/26/05, Shamil Salakhetdinov <shamil at users.mns.ru> wrote:
> <<<
> how I might speed this up?
> >>>
> Steve,
> In MS SQL you can use lightning fast query (Northwind db as example):
> select CategoryId, CategoryName
> from Categories
> order by RAND(Checksum(newid()))

More information about the AccessD mailing list