[AccessD] Random rows ?

Gustav Brock Gustav at cactus.dk
Thu Oct 23 02:54:45 CDT 2008


Hi Bob

> I was hoping to modify the table I had already created which already
> contained the values I needed, just not in a random order.

Well, that is quite different from your original statement:

> I need to create a table of one row ..

Anyway, add the autonumber field of Guid (ReplicationId) and make that the primary key.
Or, do as Stuart suggests by using Rnd(). This is also what I what do if the table exists.

/gustav


>>> bheygood at abestsystems.com 23-10-2008 00:29 >>>
You are so right.
I was hoping to modify the table I had already created which already
contained the values I needed, just not in a random order.






More information about the AccessD mailing list