Recent content by Ahmangbay30

I still have not been able to figure this out. I've even gone to the point of buying Access for Dummies haha. Instead of leaving all the questions from different categories in 1 table, I now created a table for each subject. I'm sure this will help simplify it. How can I now randomly pull a...

Ok, I've tried using this line, with no luck: (SELECT TOP 10 * FROM tblQs Where CatID=1) union (SELECT TOP 10 * FROM tblQs Where CatID=2) union ((SELECT TOP 10 * FROM tblQs Where CatID=3) union ..... If one my columns in my database is labeled "Subjects" and it has all the "Math", "Science"...

Yea, sorry if I worded it poorly. I've been able to randomize 50 questions from the 1000 questions, but I needed it to randomize 50 questions with a certain percentage of the questions being from a different category each time.

Thank you for the quick response Cronk. I'm going to try to do a little more research on the Union Queries like you suggested. With the codes that you provided, will that still randomize those percentage of questions? Also, where would I even go to input these? I'm sorry for my ignorance on...

Hi all, I'm new to the forums and new to Access. I was given a database and told to basically figure it out any way possible. Got to love it. Here's my problem: I have a database of 1000 questions, all multiple choice. Each line is broken down by ID#, Category, Question, Answer A, B, C, D...