Create data in a field with multiple lines?

[Larry Hodges]

Hi all,

Running A2k

I have to export data from Access to QuickBooks. Part of that is the
addresses for customers. The problem is, QuickBooks views the address field
as one piece of data, like a mailing label.

So, in Access, I've got the following in separate fields:

Address1
Address2
CityStateZip

Obviously, I can put these together in a query with:
ComboAddress:[Address1]&" "&[Address2]&" "&[CityStateZip]

But, can I put the above together in such a way as to move the Address2 to
the next line, and CityStateZip to the line below that within one field? I
can create a Memo field, run an append query and add those fields as one set
of data. Then export that Memo field.

Thanks in advance for the help.

 

[Rick Brandt]

Hi all,

Running A2k

I have to export data from Access to QuickBooks. Part of that is the
addresses for customers. The problem is, QuickBooks views the
address field as one piece of data, like a mailing label.

So, in Access, I've got the following in separate fields:

Address1
Address2
CityStateZip

Obviously, I can put these together in a query with:
ComboAddress:[Address1]&" "&[Address2]&" "&[CityStateZip]

But, can I put the above together in such a way as to move the
Address2 to the next line, and CityStateZip to the line below that
within one field? I can create a Memo field, run an append query and
add those fields as one set of data. Then export that Memo field.

ComboAddress: [Address1] & Char(13) & Chr(10) & [Address2] & Char(13) &
Chr(10) & [CityStateZip]

And just export the query with the above. No need to make a redundant table
with a Memo field.

 

[Larry Hodges]

Hi all,

Running A2k

I have to export data from Access to QuickBooks. Part of that is the
addresses for customers. The problem is, QuickBooks views the
address field as one piece of data, like a mailing label.

So, in Access, I've got the following in separate fields:

Address1
Address2
CityStateZip

Obviously, I can put these together in a query with:
ComboAddress:[Address1]&" "&[Address2]&" "&[CityStateZip]

But, can I put the above together in such a way as to move the
Address2 to the next line, and CityStateZip to the line below that
within one field? I can create a Memo field, run an append query and
add those fields as one set of data. Then export that Memo field.

ComboAddress: [Address1] & Char(13) & Chr(10) & [Address2] & Char(13)
& Chr(10) & [CityStateZip]

And just export the query with the above. No need to make a
redundant table with a Memo field.

Worked great. Thanks for the help.