[AccessD] Every 100th record

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