Making a value span multiple rows

T

twen

I am trying to concatenate [Street 1], [Street 2], City, State, and Zip
fields into one field called Address in a separate table. Is it possible to
create a query that would use INSERT INTO and add the next field as a new
line below the previous one? I tried using VB but all I got was the little
white and not a new line. I used vbKeyReturn. Please any help would be
greatly appreciated. Thanks
 
J

Jeff Boyce

Answered elsewhere in the 'group.

Why post the same question twice? The volunteers who visit here will
consider your question as soon as they can...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top