Windows XP, SP3 LO 4.0.5.2 We have created a Base database from Access 2003. One of the reports, based on a query, is to print labels. The first line is for the name, second line is for the company name, third line is for the street address or PO Box, and the last line is for the city, state and zip code. We would like the PO Box to show on the third line if there is no given address. Using the Function Wizard, we have tried the following: "IF([STREETNO]&" "&[STREET]ISBLANK;[POBOX];[STREETNO]&" " [STREET]") - this doesn't show any information. We tried to reverse it "IF([POBOX]ISBLANK;[STREETNO]&" "&[STREET];[POBOX]) - no data appears. We have tried to use " " instead of ISBLANK, same thing, no data.
Any ideas? -- View this message in context: http://nabble.documentfoundation.org/Address-block-in-Base-report-tp4073699.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted