[AccessD] hard carriage return in query

Mike Mattys mmattys at rochester.rr.com
Mon Feb 8 16:48:27 CST 2010


Hi Rocky,

try either chr(13) & chr(10) or /r/n

Mike Mattys

----- Original Message ----- 
From: "Rocky Smolin" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, February 08, 2010 5:40 PM
Subject: [AccessD] hard carriage return in query


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


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list