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