Results 1 to 2 of 2
  1. #1
    julestrip is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    1

    Need a query to figure all possible combinations


    Good Morning & Thanks for your help in advance

    I have a list of numbers (0-19) listed in a table (Possible Codes) with their description. I would like to write a query that could show me all the possible code combinations there could be such as this:



    2,4,7,10,14

    Some of them are dependent on other choices made earlier in the string. Such as:
    If you pick 0 you could only pick one of (3-6) and one of (7-10) one of (11-14) or (15 -19)

    If you pick 1 you could only pick one of (3-6) and one of (7-10) one of (11-14) or (15 - 17)

    If you pick 2 you could only pick one of (3-6) and one of (7-10) one of (11-14) or (15, 18, 19)


    I am really lost as to do this... I am a newbie to Access

    Thanks,
    Julie

  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,716
    I'm not sure what exactly you're trying to do, given that you have exceptions/criteria.

    Normally if you have "things" and you want all combinations, you could put the "things" in tables and do a Cartesian product. However, you are asking for all, but limiting the output based on some logic.

    I think you have to define the exception logic so others can understand what you are doing and advise accordingly.

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

Similar Threads

  1. Query for All Possible Combinations
    By Rawb in forum Queries
    Replies: 1
    Last Post: 10-09-2010, 08:33 PM
  2. Cannot Figure this query out
    By ryan1313 in forum Queries
    Replies: 6
    Last Post: 08-13-2010, 12:54 PM
  3. Multi-Query List Box Combinations?
    By BizIntelGuy in forum Access
    Replies: 3
    Last Post: 07-20-2010, 03:20 PM
  4. Replies: 5
    Last Post: 05-26-2010, 07:13 AM
  5. ms access version combinations
    By marianne in forum Access
    Replies: 1
    Last Post: 08-05-2009, 07:37 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