Statistical Sampling

[RayMilhon]

We are planning to start doing some customer Surveys. I've been tasked with setting up the Database to generate the Surveys for Member Services to Call a Random Sampling of Members Each Year. We are starting with 1 but within the next year that will grow. I've built the tables, forms and reports to be used. The last element is the random selection of members to be called.



I've created a function to return the Statistical Sample size based on our membership.

Now to the issue. Out of our membership I need to select the # of members calculated by that function and populate the call list table. The Criteria is that they must be active members and they have not been called within the previous 4 years. We have approx 18,000 members and based on the formula for sample size we must call 388 members. My thought was to create a query that included a column to generate a random number, sort on that number and select the first 388 members from that recordset. the problem is that when I run the query it's the exact same number for every member. How do I get a query to generate a random number for each record and then sort on that number?

[June7]

Review http://www.rechtman.com/randsql.html

Can't sort on the random number unless you use UPDATE method that actually stores the generated number in table.

[orange]

Ray,
see this article by Susan Harkins
http://www.techrepublic.com/blog/how...oft-access/149

[RayMilhon]

Thanks orange that article worked.

[orange]

Glad to help.