ACCESS FEED: Re: [MS_AccessPros] Re: Selecting 10% of a tables record

Kamis, 15 Maret 2012

Re: [MS_AccessPros] Re: Selecting 10% of a tables record

Duane,

That was perfect!

Thanks

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Duane <duanehookom@hotmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, March 13, 2012 2:27 PM
Subject: [MS_AccessPros] Re: Selecting 10% of a tables record

This SQL works for my table where cbnCBNID is a unique numeric field:

SELECT TOP 10 PERCENT Rnd([cbnCBNID]) AS Expr1, MyTable.*
FROM MyTable
ORDER BY Rnd([cbnCBNID]);

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I have a table called tblStudent:
>
> StudentID
> Lastname
> FirstName
> MI
> Status
> ....
>
> My supervisor has request me to select 10% of the records of the records in the table but 10% needs to be random records.
>
> No idea what to do with that any ideas>
>
> Thanks
>
> Art Lorenzini
>

[Non-text portions of this message have been removed]