Making a value span multiple rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top