Run Random Records Query - Specific Number

[Ivo]

Hi

Wonder if anyone can help. Need to write a queryto pull out 7 random records
from a table, sounds easy but is it?

Many thanks

 

[James]

Hi

This other thread may be what you are looking for... I haven't used it
but have had it bookmarked for a while as it looks useful should I
have to do the same ;D0

http://groups.google.co.uk/group/mi...ndom+record+generator&rnum=1#494c1a448adfde7b

James