Results 1 to 2 of 2
  1. #1
    Azgambit is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    Chandler, AZ
    Posts
    1

    Random Number and Comparison

    I searched the forums, but was unable to find anything that matched what I was looking for, so I opted to start a new thread. If this is already out there somewhere, I apologize for this thread

    Anyway, here is what I am looking to do:

    1.) Generate a random number between 1 and 100 and assign the result an identifier, like a person's name.
    2.) Generate a second random number between 1 and 100 and assign the result a different identifier, like another person's name.


    3.) Compare the two randomly generated numbers.
    4.) Have the identifier of the LARGER random number displayed on the screen.

    I would like to have this linked into a button click.

    I am hoping there is an easy way to accomplish this task. I am open to any help the community can provide, but PLEASE, use small words (very small). It has been quite some time since I have done any programming/design work in Access.

    Thank-you in advance to everyone!!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Here is an article on Access and random numbers with sample
    http://www.techrepublic.com/blog/how...rosoft-access/

    When you cross post, you should advise the readers.
    Here's the reasoning
    http://www.excelguru.ca/content.php?184



    Cross posted
    http://www.access-programmers.co.uk/...d.php?t=255635

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

Similar Threads

  1. Make ID field a random number
    By harrytgs in forum Access
    Replies: 13
    Last Post: 08-08-2012, 02:18 PM
  2. Number comparison help
    By kgriff in forum Access
    Replies: 13
    Last Post: 02-17-2012, 07:41 PM
  3. No-So-Random Number
    By oleBucky in forum Programming
    Replies: 8
    Last Post: 11-08-2011, 11:02 AM
  4. Sorta Random Serial Number Generator
    By Cuselco in forum Programming
    Replies: 3
    Last Post: 08-27-2010, 12:05 PM
  5. Random number generators with no repeats
    By CJ508 in forum Access
    Replies: 5
    Last Post: 10-29-2009, 07:30 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