Returning 8 records selected at random (1 Viewer)

[MikeG]

I am not that familiar with VBA or SQL coding but will take whatever you can provide. I need to pull 8 random records from the correct responses made to a weekly question we are posting on our intranet. I'm at a loss on the randomizing function mentioned elsewhere on the forum. I've tried to find information on the RND function but haven't had much luck. Can anyone help or at least point this beginner in the right diretion? Thanks,
Mike

 

[Jack Cowley]

Hopefully this article will help...

http://support.microsoft.com/search/preview.aspx?scid=/search/viewDoc.aspx?docID=KC.Q208855%26dialogID=9652711%26iterationID=1%26sessionID=anonymous|8531001%26url=kb;en-us;Q208855

 

[MikeG]

Jack, THANKS! That did the trick! My preliminary tests results look good!
Mike (Forever a Junior Member!)