Good morning all,
Here is what I'm trying to do:
Table has over 100,000 records. Within the table there is a field called Department and it contains various departments (Department A, Department B...etc). I need to run a random sample based off the number of records each Department has. For example, if Department A has more that 100 records but less than 1000 records, I need a random sample of 35 records. If Department B has more than 100 records but less than 1000 records, I need a random sample of 35 records. I ran a query to count the number of records each department has but I just can't figure out how to randomly select only X amount of records based off those numbers. I hope this makes sense. Thank you in advance for your time.