Selecting a Random Record

[Abel_Gallardo_(Guest)]

I have a table with the following fields:____TXID; ID; FNAME; LNAME; ADDRESS; CITYSTZIP; COUNTRY;____The table holds approximately 20,500 records. I need to randomly select a record. Please help.____Thanks,__Abel__abel@gwrra.org

[rickwjohnson]

Abel, I have tonight emailed to you a paper from Concentric Data on the topic of random records. Hope this helps. Perhaps it will at least get you started.__Rick Johnson____Rick Johnson