Random Sample

[Jeff]

I need to randomly select 500 clients for each manager
from my total client table. Is there a formula within
Access to do this?

 

[M.L. Sco Scofield]

Take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;287682.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com