how to copy random records from a table to another table

[venu]

iam trying online examination database for my institute. i made two tables one is questionBank fields qno,subject,chapter,typeOfQuetion,question,answer. another one is studets with fields ID,Name,Class,course. now i want to select question paper from question bank randomly with the option that i want to choose different no of quetions from each chapter to conduct exam every time.

[alcoool]

create an autonumber field in your tables then you can use a query with the RND function as a criteria

[venu]

create an autonumber field in your tables then you can use a query with the RND function as a criteria

Well, But how to choose different no of quetions from each chapter(group).