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
 
Back
Top