G
Guest
I've searched the board for the answer to my questions but I haven't been
able to find what I need. My scenario is as follows:
I have a table that with four fields and thousands of records. I am trying
to generate a random sample from the records of about 10%. That part isn't
too difficult.
What has been difficult for me is that the overall sample needs to be broken
down into four smaller samples (based on one of four values in a particular
field), than have a random sample generated for each smaller sample. Would
this part be easier by creating four seperate queries, than generating a
random sample from the query?
One method I have tried is by creating a recordset but the best I can do is
count the total records.
Do you have any ideas and the best approach to accomplish what I need?
able to find what I need. My scenario is as follows:
I have a table that with four fields and thousands of records. I am trying
to generate a random sample from the records of about 10%. That part isn't
too difficult.
What has been difficult for me is that the overall sample needs to be broken
down into four smaller samples (based on one of four values in a particular
field), than have a random sample generated for each smaller sample. Would
this part be easier by creating four seperate queries, than generating a
random sample from the query?
One method I have tried is by creating a recordset but the best I can do is
count the total records.
Do you have any ideas and the best approach to accomplish what I need?