Random Numbers with Records

[tsasa10]

I want to match Random Numbers with Names

I am building a database and I want to have 50 names and 50 numbers (1-50) Each week I want the 50 numbers to match up with a different name.

Kinda like drawing out of a hat, but instead of drawing 50 numbers out of a hat, I want the Access program to do that randomly for me. Is this possible? If so how?

Thanks

 

[IgorB]

To create random numbers each time by weekly you have to use built-in function Rnd for numbers limit and also Randomize for make sure computer generates all the time different Sequence of numbers.

 

[Phredd]

Little more help

Sorry to jump in on someone elses thread. But I have the same issue trying to generate a random Team draw, and need a little more direction than the one provided.

I have teams for example , Red, Blue, Green and Black. (Except there are 20 or more.)

Each week they need to be in a differant order. I tried =rnd() in a Query this gives them all the same number, and if done in a report won't sort. It needs to change every time the report is run...

Please help or even email me a simple example.... mickb-at-hotpop.com

Slowly going insane....

Thanks