append query help

V

Van

I have a table with 10 fields and would like append all of my fields
into 1 field without having to append the fields1 at a time. Is this
possible and if so, how?

Thanks,

Van
 
P

PW

Van said:
I have a table with 10 fields and would like append all of my fields
into 1 field without having to append the fields1 at a time. Is this
possible and if so, how?
Click to expand...

Concatenate all the fields into one string, then insert it into the target
field.
 
A

arthurjr07

SELECT FIELD1 FROM TABLE1
UNION ALL
SELECT FIELD2 FROM TABLE1
UNION ALL
SELECT FIELD3 FROM TABLE1
UNION ALL
SELECT FIELD4 FROM TABLE1
UNION ALL
SELECT FIELD5 FROM TABLE1
UNION ALL
SELECT FIELD6 FROM TABLE1
UNION ALL
SELECT FIELD7 FROM TABLE1
UNION ALL
SELECT FIELD8 FROM TABLE1
UNION ALL
SELECT FIELD9 FROM TABLE1
UNION ALL
SELECT FIELD10 FROM TABLE1
 
A

arthurjr07

SELECT
(
FIELD1 & " " &
FIELD2 & " " &
FIELD3 & " " &
FIELD4 & " " &
FIELD5 & " " &
FIELD6 & " " &
FIELD7 & " " &
FIELD8 & " " &
FIELD9 & " " &
FIELD10
) AS A
FROM TABLE1

sorry.Disregard my first post. :)
 
Top