Assign a random# (1-5) to a table of 100#'s

[IIJ]

I’m working in access and I’m trying to assign a random value from 1 to 5 to a table of 100 numbers (that are 8 digits long). For instance,

1 – 99997000
2 – 97561332
3 – 97568123
4 – 94568711
5 – 12345677
1 – 97561302
2 – 97561295
Etc….

Than repeat this process another 20 times unit all the 100 numbers have a random value from 1 to 5.

Thanks,

 

[John Big Booty]

Check out the Rnd() function.

 

[IIJ]

I tried the following:

Int ((5-1+1)*Rnd+1)

But it only selected one random value 1, 2, 3, 4 or 5 for all 100 numbers in the table.

How can I modified the formula, so that it will select a random value from 1 to 5 (1, 2, 3, 4 and 5) to the first five rolls

1 – 99997000
2 – 97561332
3 – 97568123
4 – 94568711
5 – 12345677
1 – 97561302
2 – 97561295

Then repeat the same five values to the next five rolls 6, 7, 8, 9, 10 in the table?

Thanks,

 

[jdraw]

see
http://www.techrepublic.com/blog/ho...random-set-of-records-in-microsoft-access/149

 

[IIJ]

Okay,

Thanks....