Gustav Brock
Gustav at cactus.dk
Fri May 15 10:25:12 CDT 2009
Hi Jim Not you! I've posted that code many times here and 14 times at [you know where] since 2004. I even found my function here (with left out credits of course): http://www.vbforums.com/showthread.php?t=388276 /gustav >>> jimdettman at verizon.net 15-05-2009 17:07:48 >>> Yup. Define a column as Rnd(1), sort on that column and set the TOP predicate for the query for the number of records you want.