[AccessD] Every 100th record

Gustav Brock gustav at cactus.dk
Fri Aug 27 10:21:32 CDT 2004


Hi John


> Does anyone have a strategy for pulling every Nth record?  My client wants
> to pull every 100th record into a dataset for analysis, to speed things up I
> am guessing.

To speed up what? Analysis on a sample only and not on the full set?

If so, you could select by "Random Between 1 To 100" = 1.

/gustav




More information about the AccessD mailing list