Making a value span multiple rows

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

Multiple values into one cell with each on a new line 3
Split data in field on character return 0
In search of a new Obelisk 6
Normalization: Tables for Addresses? 5
Re-organizing list information into filterable table 1
Company and multiple addresses DB design 1
help with database 2 1
Un-Concatenate 3

Top