Hi Graham, Try rnd(either a unique_ID column or NewID()) instead of rand().
> Thanks for the idea. I'm getting an error re: the 'rand' function though. > I suspect it's because Access2000 cannot handle it? I did change the rest > of the SQL to match my table fields, so I'm GUESSING it's not > with that part > of the syntax. I assumed you were using SQL server... Marc - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
