[AccessD] hard carriage return in query

It should be 13,10 - not 10,13

-- 
Stuart

On 8 Feb 2010 at 14:40, Rocky Smolin wrote:

> Dear List:
> 
> I am trying to write an update query to transfer addresses in multiple
> fields from one table to an address field in a second table which is a memo
> field.
> 
> I put Expr1: [fldVendorAddress1] & Chr(10) & Chr(13) & [fldVendorAddress2] &
> Chr(10) & Chr(13) & [fldVendorAddress3] & Chr(10) & Chr(13) &
> [fldVendorZipCode] &  Chr(10) & Chr(13) & [fldVendorCountry] as the field in
> the QBE grid.
> 
> but in the target table there are no hard carriage returns as I would expect
> from & Chr(10 & Chr1(13). Even as a select query the results are all
> concatenated.
> 
> Is there a trick to this?
> 
> MTIA
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> www.bchacc.com <http://www.bchacc.com/> 
> 
>  
> 
>  
> 
>