Random ID selection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rich (Rich_at_discussions.microsoft.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 06:57:02 -0700

Hello,
I need some help getting a random set of data ..here is the situation

My CUSTINFO table has ID field (primary key) and then other customer
information in 9000 rows of data. I need to figure out a way where I can have
a record selected randomly based on the ID.

Then perhaps every time i click a button a new random choice from the table
appears

Thanks in advance!
-Rich

Quantcast