Line breaks and line feed in a query

[Astrofax]

I have 3 address fields 1, 2 & 3 and would like to merge these into one field using a query.

I have done this using vbCrLf in forms, but would like to do this in a query - can it be done. I have tried various ways such as Chr(13) & Chr(10), but no joy.

Thanks

Philip

 

[GingerR]

=" " & Blah & Blah1 & Blah2

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Astrofax]

I entered:-

Address: " " & [address1] & [address2] & [address3]

but it returned nothing. Have I missed something?

Thanks

Philip

 

[GingerR]

if you put

Address: [address1] & [address2] & [address3]

do you get anything?


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[SeeThru]

try

Expr1: [Address1] & "
" & [Address2] & "
" & [Address3]


the quotes are quote shift-enter quote

You wont be able to see past the first quote without using shiftF2 tro zoom, but it works. Actually, using the Zoon makes building these easier.

I've gor some queries that usie iif() and various things that retun chunks of text 20 or 30 lines long.