Re: [libreoffice-users] Address block in Base report

Yes, the report will return a label showing the address or PO box on two separate lines.  However, 
we would like the PO box to show where the address line would normally be.  Seems like a function 
should work for this.  If address line available, print, if not, print PO box. 

> > > On 9/10/2013 at 10:39 AM, Jay Lozier <jslozier@gmail.com> wrote:
-----Original Message-----
From: Karen DInse <kdinse@rrwrd.dst.il.us>
To: users@global.libreoffice.org 
Subject: [libreoffice-users] Address block in Base report
Date: Tue, 10 Sep 2013 07:50:39 -0700 (PDT)

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?

Karen,

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.


-- 
Jay Lozier
jslozier@gmail.com 


-- 
To unsubscribe e-mail to: users+unsubscribe@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

------- DISCLAIMER 
-----------------------------------------------------------------------------------------------------------------------
This message and any attachments are confidential to the ordinary user of the e-mail address to 
which it was addressed and may also be privileged. If you are not one of the addressees you may not 
copy, forward, disclose or use any part of the message or its attachments.  If you have received 
this message in error, please notify the sender immediately by return e-mail and delete it from 
your system. The sender does not accept liability for any errors or omissions in the context of 
this message that arise as a result of Internet transmission. Sender accepts no liability for any 
damages caused by any virus transmitted by this email.  Any opinions contained in this message are 
those of the author and are not given or endorsed by the Rock River Water Reclamation District 
(RRWRD) unless otherwise clearly indicated in this message and the authority of the author to so 
bind the RRWRD referred to is duly verified. 
------- DISCLAIMER 
--------------------------------------------------------------------------------------------------------------------------

-- 
To unsubscribe e-mail to: users+unsubscribe@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