Random Sample

[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?

 

[KARL DEWEY]

Post your other field names with datatype and sample data so I can give a try.