dhanesh

[dhaneshjs]

Hi,



I have a database that have three columns of address (adr1,adr2,adr3)
i want to concatenate these three under one column "address".
i wrote the query to concatenate.

eg:-

adr1 adr2 adr3
abc def ghi

and i got this as

address
abcdefghi

But the issue is i want this to come as

address
abc
def
ghi

Hope all gurus understood this. Please help me with this.

Thanks in advance,
Dhanesh

[RuralGuy]

FullAddress:=[adr1] & vbCrLf & [adr2] & vbCrLf & [adr3]

[dhaneshjs]

Hi RuralGuy,

It didn't solved my problem. still some part of first line address is coming with second address.

[RuralGuy]

I would examine the records where you see this issue. I believe it is a data issue.