Random selection of records 1

[rkl58]

I have a table (tblClaimHistory) with 1,000 plus records. I need to create a method to randomly select 25% of the records. Any solutions?

 

[dhookom]

Here is the SQL to select 25% of the records from the Orders table in Northwind.mdb:

SELECT TOP 25 PERCENT Rnd([OrderID]) AS Expr1, Orders.*
FROM Orders
ORDER BY Rnd([OrderID]);

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]