Eliminating Blnk Address Lines

  • Thread starter Thread starter Paul Richards
  • Start date Start date
P

Paul Richards

I have a query from which an invoice is printed. How do I eliminate
blank address lines?

For example if I have address_line1, address_line2,
address_line3,address_line4, post/zip code and there is data only in
address_lines 1 and 2 and post/zip/code,how do I eliminate the two blank
lines when printing the invoice?

Thanks
 
this has been answered in

microsoft.public.access.queries


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating Blank Address Lines 9
How to eliminate blank line 5
removing blank lines from addresses in a report 3
Printing an address in letter 5
Cancel printing blank lines 1
How to add a return in a text box if second field has data 7
Fax Individual Report via command line 1
Eliminating a field if it's blank 2

Back
Top