Rocky Smolin
rockysmolin at bchacc.com
Mon Feb 8 23:07:53 CST 2010
True. This is a one-shot so I was looking for the Q&D approach. The function would give a better result though. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell Sent: Monday, February 08, 2010 7:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] hard carriage return in query Rocky, Another way is to have a function that formats the address. This allows for more flexibility of screening out empty fields, include/exclude country, formatting zip code for both 5 digit and 9 digit values, etc. Just call the function and pass the values as parameters in the QBE. Expr1: FormatAddres([fldVendorAddress1], [fldVendorAddress2], [fldVendorAddress3], [fldVendorZipCode], [fldVendorCountry]) Joe O'Connell -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, February 08, 2010 8:05 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] hard carriage return in query But will it work in the field name of the QBE? vbCrLf didn't. And therein lay the problem. For seniors. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, February 08, 2010 4:49 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] hard carriage return in query Hi Rocky, There's an easier parameter --> vbNewLine Use this in place of chr(10) & chr(13). Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, February 08, 2010 4:40 PM To: 'Access Developers discussion and problem solving' 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com