Results 1 to 3 of 3

Thread: Lottery Program

  1. #1
    Join Date
    Oct 2005

    Unanswered: Lottery Program

    Hello- I am a Part-Time Intermediate Access Developer looking for suggestions with the following problem I am having.

    I am trying to develop an Access DB that will be used for playing a Sports Lottery. The Lottery Game requires you to pick the correct outcome of all games in on a Card (12/13 or 14 games) and the ticket containing the most correct games wins (this is most often %100).
    When completing the ticket you are given the choice of a game number (1) and whether you selecting the Home Team (H) or the Visiting Team (V) so each selection has 2 possible choices
    Game number Home Visitor
    1 Check Box Check Box
    2 Check Box Check Box
    3 Check Box Check Box
    4 Check Box Check Box
    5 Check Box Check Box
    The problem I am having is I am trying to create a query that will take my 12 selections and compute all the combinations possible assuming I will get 2 games wrong. This is based on a 10 of 12 permutations consisting of 66 tickets with the remaining 2 games actually selecting the opposite of what I picked.
    My Selections

    First ticket would be

    Also I am not sure whether to use
    Check Box
    Option box
    List/ Combo Box

    Any suggestions regarding this would be appreciated.
    Paul Sullivan

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    Sounds like an interesting problem, but I am not sure what you are asking for. If you had a query that gave you all of the combinations with 10 correct answers, what do you then plan to do with it?

  3. #3
    Join Date
    Oct 2005
    they will be the tickets purchased

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts