Results 1 to 2 of 2
  1. #1
    graviz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    48

    Random Rdn() Funtion Help Please

    I have a query of a bunch of records and I'm trying to assign a random number to each one. The issue is when the data pulls, it's giving the same number to each record. My expression is below:

    Random: Int((999-100+1)*Rnd()+100)



    I've also tried just Rnd() and it also doesn't work.

    Any idea what I'm doing wrong

  2. #2
    graviz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    48
    I fixed it. I just needed to use the Randomize function.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Random number generators with no repeats
    By CJ508 in forum Access
    Replies: 5
    Last Post: 10-29-2009, 07:30 AM
  2. Replies: 2
    Last Post: 09-10-2009, 05:42 AM
  3. Random numbers
    By Gator777 in forum Access
    Replies: 3
    Last Post: 08-12-2009, 10:04 AM
  4. random record
    By wasim_sono in forum Programming
    Replies: 1
    Last Post: 02-06-2008, 02:42 PM
  5. generating random numbers on form
    By anitra in forum Forms
    Replies: 1
    Last Post: 02-14-2006, 10:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums