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

    Number prediction from a lottery database Please I NEED ASSIST

    Hello Access,



    I want to know is it possible and if so I need your help if a person has a database in and they want to to predict the likely-hood of a certain number been drawn. How would they do that for instance, the lottery in most states have a quick pick and I want to know if you had all the numbers that ever came in the last 20 years along with the date, day, and number drawn. I want to know how can you create a database generator that if you put in for instance the day 12/20/2015 and you click enter I want to be able to see what number would likely be drawn. But also I would like to see the numbers that came two days before 12/20/2015 and 3 days after 12/20/2015 please if you have an sql statement or anything Please I am very curious, please assist me

    Thank you in advance,

    TheSpecialist

  2. #2
    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
    You might want to review Random Number before putting too much effort into your project.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Your question doesn't make sense. If you are loading historical lottery data (individual numbers and dates of the drawings) you have no need of random numbers. The likelyhood of any given number does not change regardless of drawing date or the previous drawing's numbers.

    Let's say your lottery has 49 numbers and 6 numbers comprise a drawing. Your chances of drawing a 1 on any given ball are the same.

    1/49 on the first ball
    1/48 on the second ball
    1/47 on the third ball
    1/46 on the fourth ball
    1/45 on the fifth ball
    1/44 on the sixth ball

    The chance of the number 1 appearing in any given drawing has absolutely nothing to do with what the prior drawing contained, nor any other drawing for that matter.

    If your assumption is that 'well the number 1 appeared on the last drawing, therefore it's not going to appear on this drawing' you're starting with the wrong assumption No such correlation exists.

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

Similar Threads

  1. Some SQL beyond my abilities (please assist)
    By hellfire45 in forum Access
    Replies: 1
    Last Post: 03-18-2015, 07:00 AM
  2. Assist with results
    By GregRemaly in forum Queries
    Replies: 8
    Last Post: 10-08-2014, 12:45 PM
  3. Lottery Database
    By bigroo in forum Access
    Replies: 3
    Last Post: 03-06-2012, 05:48 PM
  4. Senseless, but please assist
    By djclntn in forum Queries
    Replies: 7
    Last Post: 11-21-2011, 07:02 PM
  5. **I need Help with EXCEL. Please Assist**
    By n in forum Import/Export Data
    Replies: 0
    Last Post: 06-23-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