Ok, y'all - I give up on this one! I am trying to print a membership
directory. The format is like this:
Company Name
Contact Name
Address
City, State Zip
Billing Address
Billing CSZ
Phone
FAX
EMail
WebSite
Sounds simple, but the member may or may not have a contact, billing address,
phone, fax, email, website, or any combination of those elements missing. I
have been "clever" enough to make enough variables to account for each missing
element. The object here is to have the listing with no spaces for missing
elements nor duplicated information. There are 3 possible variations on the
address:
1. Street & Bill same:
Address
CSZ
2. Street & Bill different, CSZ same:
Address
Billing Address
CSZ
3. Street & Bill different:
Address
CSZ
Bill Address
Bill CSZ
As I said, I can actually get all this to work right, but when I go to print my
report to an Excel file, it will randomly lose a contact name, email address,
or something. For the life of me, I cannot figure out why this is happening.
I would think it may be a misinterpretation of a delimiter but I can't seem to
find a pattern to it. Can anyone help?
Thanks in advance!
Jan Barley
