A
Andrew Banks
I'm trying to order a recordset randomly. I've tried the following
ORDER BY Rnd(ProdID) - ProdID is my primary key
I've read that this will be random but will always return the same random
order. I've also read that using the following should resolve this
ORDER BY Rnd(Timer()) - this still gives me the same problem
I've only got 16 recors in the DB at the moment if this is relevant.
Can anyone help me return my recordset in a new random order every time
EVERY time
Thanks in advance
ORDER BY Rnd(ProdID) - ProdID is my primary key
I've read that this will be random but will always return the same random
order. I've also read that using the following should resolve this
ORDER BY Rnd(Timer()) - this still gives me the same problem
I've only got 16 recors in the DB at the moment if this is relevant.
Can anyone help me return my recordset in a new random order every time
EVERY time
Thanks in advance