multipule columns as on column

[gz3d2h]

I need to create a make-table query containing 6 fields..

I have 16 fields in the original table. The first is a primary key, the next
fifteen and actually three groups of five (a,b,c,d,e,a1,b1,c1,d1,e1,a2,b2,c2,
d2,e2) the need to be output as a,a1,a2 into a field called last name (not
concatenated), b,b1,b2 into a field called first name...etc...

Does anyone have any ideas

 

[John W. Vinson]

I need to create a make-table query containing 6 fields..

I have 16 fields in the original table. The first is a primary key, the next
fifteen and actually three groups of five (a,b,c,d,e,a1,b1,c1,d1,e1,a2,b2,c2,
d2,e2) the need to be output as a,a1,a2 into a field called last name (not
concatenated), b,b1,b2 into a field called first name...etc...

Does anyone have any ideas

Sounds like you have a pretty serious normalization problem! A "Normalizing
Union Query" may be the solution, but your rather abstract description has me
wondering what field goes where. You say you want a, a1, a2 into a field
called last name - in three records? one record?

What's the actual data in a record, and what do you want in the output? Do you
want three records with five fields? Where should the primary key from this
table appear, if anywhere?


John W. Vinson [MVP]