Move data to the most left column (1 Viewer)

curtyrut · Feb 10, 2016

What if the columns are not consecutive? For example, address 1, update address 1, address 2, update address 2, ......etc?

Thanks.

MarkK · Feb 10, 2016

Do this in a query (at retrieval time, easy), not in code (moving data around inside your db, hard) . . .

Code:

SELECT Field1 & Field2 & Field3 & Field4 As Address 
FROM tTable

Done. Easy.

Different fields on different lines? Write a new query! Easy.

Code:

SELECT Field12 + chr(13) + chr(10) & Field13 + chr(13) + chr(10) & Field14 As CherryPickedMultiLineAddress
FROM tTable

Delimit the fields differently? New query . . .

Code:

SELECT Field1 + "|" & Field2 + "|" & Field3 As DelimitedAddress
FROM tTable

Storing data is easy. Retrieving data is easy. Moving data around inside your database is hard. IMO.