Search results

  1. I

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

    Okay, Thanks....
  2. I

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

    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 –...
  3. I

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

    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...
    • IIJ
    • Thread
    • Replies: 4
    • Forum: Queries
  4. I

    Analyst

    Hi, I'm IIJ who reasoning being working with Access and VBA. My knowledge with these two types of software’s is very basic and I was hopping to learn more of from this web page.
Back
Top Bottom