From: Karen DInse <firstname.lastname@example.org>
Subject: [libreoffice-users] Address block in Base report
Date: Tue, 10 Sep 2013 07:50:39 -0700 (PDT)
Windows XP, SP3
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.
Without the function does the query return the correct information?
A typical SQL query would look like this:
SELECT person, company, address1, address2, city, state, zip (use your column names)
FROM contacts (use your table name(s))
Also, does the form/report return a label that is correct without the function?
I have found sometimes trying the minimalist approach first yields the results I wanted.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy