Hmm, thanks so much Karen. I didn’t know about the IFNULL function at all J
But Now I’m curious as to what data type I should be using. When I use TEXT I get the character representations of the char(13) and char(10)… As in: name1□□name2□□name3□□address1□□etc.. But it’s not actually creating new line like I would expect a carriage return to do. L Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, December 26, 2008 10:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Formatting labels I feel your pain. This isn't real easy to do. You can do this with 2 report expressions. Here's 2 that I used. I think you can probably understand the logic and replace your own column names within these variables. I have no continuation characters in here. This assumes that there is always something in CompanyName and Address1. vCR = ((char(13)) + (char(10))) vAddressAll = (CompanyName + .vcr + Address1 + .vcr + (IFNULL(Address2,NULL,(Address2+ .vcr))) + (IFNULL(City,NULL,(City + ', '))) + State & ZipCode) IN Customers WHERE CustomerID = CustomerID Karen I need to create some mailing labels and I can’t figure out how to keep the data merged together on the individual labels. What I’m trying to do may be better explained by example… The table storing the customer data has fields like name1, name2, name3, address1, and address2.
