setting up a question bank
I need to set up a database of questions where a subset will be used for practice tests. The criterion for the subset is that it hasn't been used in the prior 6 months. 30 questions that meet the criterion would need to pulled into the subset and printed.
I know how to set it up so I can extract ones that haven't been used in the last 6 months but I don't know how to pull the subset of 30 random questions. From another post about a similar scenario, it seems like using the Random function would play a role but I'm not sure how to create a subset of only 30.