Select a Random Number of Records

[speltrain]

I have a pretty simple database application consisting of some forms queries and tables. The main point is that I need to select a random 10% of the records in table tblMain and place them in a new table tblAudit.

Is there a way to do this simply within SQL or can someone help me out with the coding.

I'm kind of new to this SQL stuff and just starting to figure it out.

Thanks

 

[Golom]

Check out Bob Schriver's technique in thread701-824877.

 

[scriverb]

Thanks Golom for the referral.

Speltrain: You can modifiy the technique slightly to include the PERCENT capability by modifying the code in the last section. Just add the word PERCENT in front of the star(*) where the codes builds the new query SQL string. Make sure a space is maintained in front of PERCENT.

Good luck.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[speltrain]

Thanks guys, I got it to work with the code from the refered post. Thanks Bob

 

[scriverb]

Glad that Golom and I could help you with this situation.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]