Random Selection of Records

[Guest]

Hi

I have a need to generate a report showing a 10% Random selection of
records. There will be an initial criteria of a date, then I need to have a
random selection of 10% of the selected records displayed on the form.
Is the 10% part achievable and the random part also achievable, if they are
how would I go about this.


many Thanks

Richard

 

[Guest]

Look at this link on "Using a Query to display Random Records"

http://www.databasedev.co.uk/random_query.html


With the Top example use instead

Select Top 10 Percent ....

 

[Guest]

SELECT TOP 10 PERCENT asa.*
FROM asa
WHERE randomizer()=0
ORDER BY Rnd(IsNull([asa].[AsaID])*0+1);

Put in the proper table name for "asa".
For AsaID put in a field name for an Autonumber field.

 

[Guest]

Hi Jerry
The randomizer() function need to be defined

Look at this link:

http://www.mvps.org/access/queries/qry0011.htm

--
Good Luck
BS"D

SELECT TOP 10 PERCENT asa.*
FROM asa
WHERE randomizer()=0
ORDER BY Rnd(IsNull([asa].[AsaID])*0+1);

Put in the proper table name for "asa".
For AsaID put in a field name for an Autonumber field.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi

I have a need to generate a report showing a 10% Random selection of
records. There will be an initial criteria of a date, then I need to have a
random selection of 10% of the selected records displayed on the form.
Is the 10% part achievable and the random part also achievable, if they are
how would I go about this.

many Thanks

Richard

 

[Guest]

Doh! Thanks for keeping me straight!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi Jerry
The randomizer() function need to be defined

Look at this link:

http://www.mvps.org/access/queries/qry0011.htm

--
Good Luck
BS"D

SELECT TOP 10 PERCENT asa.*
FROM asa
WHERE randomizer()=0
ORDER BY Rnd(IsNull([asa].[AsaID])*0+1);

Put in the proper table name for "asa".
For AsaID put in a field name for an Autonumber field.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi

I have a need to generate a report showing a 10% Random selection of
records. There will be an initial criteria of a date, then I need to have a
random selection of 10% of the selected records displayed on the form.
Is the 10% part achievable and the random part also achievable, if they are
how would I go about this.

many Thanks

Richard