Radom Sample with criteria
Posted on 2004-04-09
I have a table with 20k+ records. The records can be seperated into 6 different business units, "c", "d","e","f","g",or "h". Every month I have to extract a certain number of records for a random sample from each business unit to send surveys to. In this table are people that we have already sent surveys to, but have a date populated in the "date_mailed" field. Currently, we are using SPSS syntax to extract the samples. I would rather bring it back into Access so everything is housed in one spot. I would like all the random sample records to be in one table so that I can do mail merges and queries off of it.