troubleshooting Question

Need help building and Access (mdb) table from an existing table in VB.NET 2010

Avatar of charlieb01
charlieb01 asked on
Programming Languages-OtherMicrosoft Access.NET Programming
6 Comments1 Solution629 ViewsLast Modified:
I have an Access (MDB) database that contains a table named NOZZLES and need to create a new table caalled NOZZLECOMBO. All of this need to be done programatically in VB.NET 2010.
I can create the template for the NOZZLECOMBO table but need help getting the data in.
Basically I have a NOZZLES table that consists of various size flow nozzles (sometimes the same size appears mor than once but needs to be treated separately since its exact measurement may differ from the other nozzle of the same nominal size.

Ultimately my progarm will use the data in the NOZLECOMBO table to determine which nozzle combination to use for a specific task.
Here is the layout of the NOZZLES table

NozID      NozSize      LOLO      LO      HI      HIHI
Noz1      3      100      150      275      300
Noz2      4      200      260      600      700
Noz3      5      500      650      900      1000
Noz4      6      700      800      1100      1300
Noz5      6      700      800      1100      1300


And here is a possible layout of the NOZZLECOMBO TABLE that needs to be built:

Comb      Noz1      Noz2      Noz3      Noz4      Noz5      LOLO      LO      HI      HIHI
1      3                              100      150      275      300
2            4                        200      260      600      700
3                  5                  500      650      900      1000
4                        6            700      800      1100      1300
5                              6      700      800      1100      1300
6      3      4                        300      410      875      1000
7      3            5                  600      800      1175      1300
8      3                  6            800      950      1375      1600
9      3                        6      800      950      1375      1600
10            4      5                  700      910      1500      1700
11            4            6            1100      1360      2250      2600
12            4                  6      900      1060      1700      2000
13                  5      6            1200      1450      2000      2300
14                  5            6      1200      1450      2000      2300
15                        6      6      1400      1600      2200      2600
16      3      4      5                  800      1060      1775      2000
17      3            5      6            1300      1600      2275      2600
18      3      4            6            1000      1210      1975      2300
19      3            5      6            1300      1600      2275      2600
20            4      5      6            1400      1710      2600      3000
21                  5      6      6      1900      2250      3100      3600
22      3            5      6      6      2000      2400      3375      3900
23      3      4      5      6      6      2200      2660      3975      4600


Some combinations may seem to be duplicate but as I said the actual size of a nozzle may differ from one of the same nominal size (there may be two 6 inch nozzles but the first may actually be 5.95 and the other may be 6.1 and that will change the flow capacity.

My program will always try to use numbers between LO and HI but I will allow it to got down as low as LOWLOW and as high as HIHI

So what I need is help building the NOZLECOMBO table - making sure all of the possible combinations exist and end up in ascending order based on the LOLO data for each combination.
One final point: these may be as many as 12 different nozzles (depending on the application) but I think if I can get help with 5 nozzles then 12 will jest be more of the same.

Thanks, Charlie
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros