Random Records

[Dean Redding]

Further to my questions, I am creating a Trivia Database with question and answers.

I want to run a report, where I can go into my database and show me a random list of 50 records. (ie. Question & Answers)

(each record contains a question and answer)

and print them out.

I know out to create a layout and to print, but don't know how to pull 50 records randomly every-time I run the script.

Many Thanks,

Dean

[comment]

See if this helps.