[AccessD] Random ina query

Hi Jim

But you forgot to close and relaunch Access - that's the trap.

If you do so, not only the first run (run 1) but every run (run n) of the query will be identical to run 1 and run n of the query of any previous session.

/gustav


>>> jimdettman at verizon.net 15-05-2009 19:02:42 >>>

gustav,

  Well I just tried it here and it works fine.  On a table of 16,000
records, I asked for the top 5 and I got a different set of five records no
matter how many times I executed the query.

Jim.