Results 1 to 6 of 6
  1. #1
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47

    How to create a random Number generator or a number predictions generator in Access

    Hi,



    I wanted to know how to create a random number generator from your already created database. The database is located in Access. Is there any way I could predict the likely hood of the number next in sequence. Like what is the next three numbers likely to appear. Is this possible.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you have the algorithym , then yes.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If it is a random number, then it will be random.
    If you are looking for random numbers between say 1 and 50, then all you can know for sure is the next number will be between 1 and 50.

    see this for more info

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If the selection is random, how do you expect to predict it? That's how casinos get rich, people thinking they have "beat the system". If I flip a coin, the odds are 50-50 it will come up heads. If it comes up heads 10 times in a row, the 11th flip still has 50-50 odds.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47
    Thank you do you know a algorithm I can use?

  6. #6
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    You can get the algorithm in any good handbook/site about statistics and probability calculations

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

Similar Threads

  1. Randon Number Generator
    By DallasW in forum Queries
    Replies: 2
    Last Post: 09-22-2015, 10:40 AM
  2. Rnd function error (Random Number generator)
    By SiciliandoBlue in forum Access
    Replies: 11
    Last Post: 09-02-2015, 03:06 AM
  3. random number generator
    By scottdg in forum Programming
    Replies: 22
    Last Post: 05-12-2015, 01:36 PM
  4. Number generator without Autonumber?
    By Megood in forum Programming
    Replies: 7
    Last Post: 07-19-2012, 08:02 PM
  5. Sorta Random Serial Number Generator
    By Cuselco in forum Programming
    Replies: 3
    Last Post: 08-27-2010, 12:05 PM

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