Try posting your question from this web page (you may have to register first
-free).
http://www.experts-exchange.com
See the section Databases => Access.
I would be interested to hear of any solutions, as I would also like to be able
to do this in Access (I have been exporting tables to Excel or S-Plus for
sampling).
Simon Fear wrote:
> Dear All,
>
> does anybody out there have a macro for taking a random sample from a table
> of records, strictly within MS Access?
>
> I know one (very clumsy!) way of doing it: append the table to a new table
> that has a random autonumber, sort on the autonumber, append to a new table
> that has a sequential autonumber, select query on autonumber <= N. But
> that's just horrible. Surely there is a better way in a Visual Basic loop
> (e.g. using the algorithm of the well-known, web-accessible SAS macro) ...
> would some kind soul spare me the trouble of learning the gruesome details
> of yet another programming language?
>
> Any help much appreciated
>
> Simon Fear
>
> ********************************************
> Dr S.C. Fear
> Statistician Hon. Lecturer
> Roy Castle ICLCR Dept Math. Sci.
> 200 London Road University of Liverpool
> Liverpool L3 9TA Liverpool L69 3BX
>
> [log in to unmask] [log in to unmask]
--
=======================================
Steve Bousquin
Kissimmee River Restoration Division
South Florida Water Management District
West Palm Beach, FL
[log in to unmask]
=======================================
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|