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