S
Student Databaser
I have a table with listings of centers across 16 regions. I need to have a
random sample that represents all 16 regions. I have tried
SELECT TOP 95 *
FROM [MyTbl]
ORDER BY Rnd(ID);
One problem that i have is that some of the regions are "3-A" or "2-B" etc,
so it doesn't work to simply replace "ID" with "region" because ID is a
numeric field, and region is text. So i created an auto number for each
center (ID). So this gives me a random sample of the ID numbers, but really
i need a random and representative sample of the centers by region.
Any ideas?
random sample that represents all 16 regions. I have tried
SELECT TOP 95 *
FROM [MyTbl]
ORDER BY Rnd(ID);
One problem that i have is that some of the regions are "3-A" or "2-B" etc,
so it doesn't work to simply replace "ID" with "region" because ID is a
numeric field, and region is text. So i created an auto number for each
center (ID). So this gives me a random sample of the ID numbers, but really
i need a random and representative sample of the centers by region.
Any ideas?