An easy one i think ?

[MarkyP]

Hi - I think this can be quickly sorted.

I use the following code in my query to merge together my customers details to 1 field:

LeadName: [Title] & Space(1) & [FirstName] & Space(1) & [LastName]

I want to do it for their address, what do i use instead if SPACE so that i get a NEW LINE each time rather than1 space to the right?

Thankyou

 

[Shaft]

Use chr(13) to get a line feed.

Good luck