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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address Format changed after Migration 0
Multiple values into one cell with each on a new line 2
VBA concatenate ranges into a new document 0
Anything will help 0
How to use matching values in two worksheets to return another value 5
Link a text box based on drop down box with four options MS Word 365 0
Special characters 3
Calculate the median value before a specified list 0

Top