TCARPENTER
Programmer
Can't seem to find what I'm looking for - I could easily have missed it or just plain not searched for the right thing - it's been a while since I used Access...
I think I'm close, but I can't quite seem to get there - but I have two tables, one is basically a lookup table (Table1), the other is the table I'm trying to flesh out (Table2). I thought either a union query or a left/outer join would populate the missing fields but it's obviously not working.
So based on Dia, Table2 (or maybe even a third table) would contain all the information from Table1.
Thanks for any help
Todd
I think I'm close, but I can't quite seem to get there - but I have two tables, one is basically a lookup table (Table1), the other is the table I'm trying to flesh out (Table2). I thought either a union query or a left/outer join would populate the missing fields but it's obviously not working.
Code:
[u][b]Table1:[/b][/u]
[b]Dia C H A D F T J[/b]
#0-80 0.004 0.06 0.096 0.06 0.074 0.025 050
#1-64 0.005 0.073 0.118 0.073 0.087 0.031 0.0625
#2-56 0.008 0.086 0.14 0.086 0.102 0.038 0.078125
#3-48 0.008 0.099 0.161 0.099 0.115 0.044 0.078125
#4-40 0.009 0.112 0.183 0.112 0.13 0.051 0.09375
#5-40 0.012 0.125 0.205 0.125 0.145 0.057 0.09375
#6-32 0.013 0.138 0.226 0.138 0.158 0.064 0.109375
#8-32 0.014 0.164 0.27 0.164 0.188 0.077 0.140625
Code:
[u][b]Table2:[/b][/u]
[b] Descr Length Dia[/b]
#0-80x1 1 #0-80
#0-80x1 .25 1.25 #0-80
#1-64x1 1 #1-64
#1-64x1.25 1.25 #1-64
#1-64x1.5 1.5 #1-64
#2-56x1 1 #2-56
#2-56x1.25 1.25 #2-56
#2-56x1.5 1.5 #2-56
#2-56x1.75 1.75 #2-56
#3-48x1 1 #3-48
#3-48x1.25 1.25 #3-48
#3-48x1.5 1.5 #3-48
#3-48x1.75 1.75 #3-48
#3-48x2 2 #3-48
#4-40x1 1 #4-40
#4-40x1.25 1.25 #4-40
#4-40x1.5 1.5 #4-40
#4-40x1.75 1.75 #4-40
#4-40x2 2 #4-40
#4-40x2.25 2.25 #4-40
#5-40x1 1 #5-40
#5-40x1.25 1.25 #5-40
#5-40x1.5 1.5 #5-40
#5-40x1.75 1.75 #5-40
#5-40x2 2 #5-40
#5-40x2.25 2.25 #5-40
#5-40x2.5 2.5 #5-40
#6-32x1.25 1.25 #6-32
#6-32x1.5 1.5 #6-32
#6-32x1.75 1.75 #6-32
So based on Dia, Table2 (or maybe even a third table) would contain all the information from Table1.
Thanks for any help
Todd