filter out randomly?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sally t - 24 Nov 2005 12:50 GMT

Can I ask Access to filter out say, 100, randomly chosen records from a large
list? ie no criteria but just specify the number of random records I want?

Thanks
Sally T

PS If not - does anyone know how to do this in Excel?

Reply to this Message

Marshall Barton - 24 Nov 2005 16:22 GMT

>Can I ask Access to filter out say, 100, randomly chosen records from a large
>list? ie no criteria but just specify the number of random records I want?

SELECT TOP 100 keyfield, posfield, fieldA, . . .
FROM table
ORDER BY Rnd(posfield)

Don't forget to use the Randomize statement somewhere before
running the query.

The field name used in the Rnd function can be any field
that contains only positive numbers, no zeros, no negatives
and no Nulls.

Signature

Marsh
MVP [MS Access]

Reply to this Message

sally t - 24 Nov 2005 21:04 GMT

many thanks!

sally

> >Can I ask Access to filter out say, 100, randomly chosen records from a large
> >list? ie no criteria but just specify the number of random records I want?
[quoted text clipped - 9 lines]
> that contains only positive numbers, no zeros, no negatives
> and no Nulls.

Reply to this Message

KARL DEWEY - 25 Nov 2005 05:39 GMT

Excel can by adding another column and filling with number generated using
the random function. Soet on the random number column and then select the
first 100.

> Can I ask Access to filter out say, 100, randomly chosen records from a large
> list? ie no criteria but just specify the number of random records I want?
[quoted text clipped - 3 lines]
>
> PS If not - does anyone know how to do this in Excel?

Reply to this Message