Combining multiple fields into one field (list).

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hcdw29 - 02 Dec 2005 15:39 GMT

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?

Reply to this Message

Newbie - 02 Dec 2005 16:35 GMT

Combined:=field1 & field2 & field3

hth

>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?

Reply to this Message

hcdw29 - 02 Dec 2005 19:10 GMT

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.

Reply to this Message

Duane Hookom - 02 Dec 2005 19:41 GMT

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];

Signature

Duane Hookom
MS Access MVP

> As suggested: Combined:=field1 & field2 & field3
> Resulted in
[quoted text clipped - 8 lines]
>
> When 1 is the ID and 2,3,4 are the unique numbers.

Reply to this Message