Access 2003 report, adding two fields together

[yoda]

ok, I'm creating a report letter in access.
I've got it to put the results from a queery into their boxes.
The problem is that Address line 2 needs to be added onto the end of address line 1....
They are both txt fields...

I've tried seperating them with a . as per reg exp, tried a space, tried a plus.

None have worked. Does anyone have any idea howq to do it?

Thanks

 

[Fezzer]

Try an ampersand: &

 

[Naqi]

Try: -

[Address1] & [Address2]