[AccessD] hard carriage return in query

Rocky Smolin rockysmolin at bchacc.com
Mon Feb 8 19:04:14 CST 2010


Ouch! I dope slapped myself. 

13, 10 

You are correct, sir.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys
Sent: Monday, February 08, 2010 2:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] hard carriage return in query

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
> 

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