[MS_AccessPros] Random Select

 

Is there a way to randomly select records within a recordset using an SQL Select statement? The objective is, we are pulling a set of records that meet certain criteria, but want to select a specified number of those records randomly. So basically, let's say we have 500 records in the recordset. We want to randomly order these records. Is there a way to randomly order a recordset?

Thanks in advance!
Mike

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___