how do I embed a line feed in a memo field via Query

[Guest]

I am trying to create a Memo field for an Address block based upon four
address lines (text fields) and want to seperate each with linefeed/Carriage
return.

How do I embed the line feeds in the update query

Thanks

 

[Rick B]

If you already have the components of the address in your table, why are you
duplicating that data in the MEMO field? This is not proper database
design. It is redundant and leads to slower response and the possibility of
data being messed up. What if an address changes? Do you really want to
fix it in two places?

 

[John Spencer]

To add a linefeed between items in a query.

SELECT FieldA & Chr(13) & Chr(10) & FieldB as Combined.

In the grid:
Field: Combined: [FieldA] & Chr(13) & Chr(10) & [FieldB]