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

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

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