[AccessD] A2003: Random order

Hi Steve

Why not make that table a two-field table.
Fill the other field, say RndID, with random numbers when the table is created.
Now read from the table QID ordered by RndID.

/gustav

>>> erbachs at gmail.com 26-10-2005 16:48 >>>
In the code I first run a MakeTable query to create a temporary,
single-field table containing just the QID field, renamed to TestQID. 100
rows numbered from 1-100.