Selecting Random Questions From Access

I have a program that is 99% complete but I ran into a bug that need resolving. This is the issue I have a VB app that generate multiple choices questions from an Access database. The questions are seperated by categories in Access. The way the program should work is that the admin should be able to have the application generate a specified amount of questions from each section randomly. For instance, let's say that there are 10 sections containing 20 questions for a total of 200 questions in the database. Let's say that a test consist of 20 questions. I would like to have the database generate 2 questions from each of the sections for a total of 20 questions, However the Admin will have the ability to set the number of questions up to the amount that is in the database. I have an admin section already created where I can tell the program how many questions to generate randomly, how many points for correct or wrong, etc. The problem is that the database will not work unless I set the amount of questions on the exam to the total amount of questions in the database. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Win 95/98/NT/ME/2000/XP