append query help

  • Thread starter Thread starter Van
  • Start date Start date
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
 
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.
 
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
 
SELECT
(
FIELD1 & " " &
FIELD2 & " " &
FIELD3 & " " &
FIELD4 & " " &
FIELD5 & " " &
FIELD6 & " " &
FIELD7 & " " &
FIELD8 & " " &
FIELD9 & " " &
FIELD10
) AS A
FROM TABLE1

sorry.Disregard my first post. :)
 
Back
Top