Division A A=150 86 armor field 3-4
B B B=151 87 B field 3-4
C, 152 C, 88 C=C field 3-4
D D D D=89 153 field 3-4
E E E E=90 154 field 3-4
F F 155 91 F F=field 3-4
Heptyl G 156 G, 92 G=field 3-4
Xin H 157 93 H=field 3-4
Nonyl I 158 94 nonyl I=field 3-4
J J J J=95 159 field 3-4
A 160 96 K...
B, 161, 97 L...
C M, 162, 98...
D N 163 99...
E A 164 100...
F, 165, 101 B...
G C 166 102...
Zinn D 167 103...
I E 168 104...
... ...
... ...
... ...
...
...
...
...
...
Vb code query access. Don't know how many letters are there in the field 1 and 2, each combination of values are required to come out, ask the great spirit guide, with what to query statement can come out??????
CodePudding user response:
The select field 1, field 2, (field 3-4) as field 5 from the name of the table