Combining multiple fields into one field (list).

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table whose records have four fields. One is an id number and the
other three fields contain a unique number assigned to that id. I want to
combine all of these assigned numbers into one field so i can make a list of
the assigned numbers. How do I do this?
 
As suggested: Combined:=field1 & field2 & field3
Resulted in
Number ID
234 1

Desired result
Number ID
2 1
3 1
4 1

When 1 is the ID and 2,3,4 are the unique numbers.
 
You could use a normalizing union query:
SELECT ID, FieldA as TheNumber
FROM [a table whose records have four fields]
UNION ALL
SELECT ID, FieldB
FROM [a table whose records have four fields]
UNION ALL
SELECT ID, FieldC
FROM [a table whose records have four fields]
UNION ALL
SELECT ID, FieldD
FROM [a table whose records have four fields];
 
Back
Top