I have a table in another db that I have to extract data from and work with it in Access. The issue is that one table is poorly constructed so I need to take 7 fields from that table and make them one field. Such as:
field 1=106 field 2=107 field 3=108
I really need this to have all values of 1, 2 and 3 under field 1 but not concatenated. Any ideas?
field 1=106 field 2=107 field 3=108
I really need this to have all values of 1, 2 and 3 under field 1 but not concatenated. Any ideas?
