Trimming fields that don't have data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a members DB and some members have alternate addresses. I have fields
for address, address1, etc, and then addresssecond, citysecond, statesecond,
etc. If the second address data doesn't exist, the report shows a , (see
paste below) for the citysecond, statesecond zipsecond etc.:

Ms. Jan
Web Editor
This Company
Park Avenue
Anytown, IL 12345 USA
(e-mail address removed)
,
Date Appointed:
Date Accepted:

Since Trim doesn't work for the comma combining these fields, what is the
code to delete this line?

Thanks
 
This is posted pretty often.

You use something like...

=([City] + ", ") & ([State] + " ") & [Zip]

The "+" will only print the items if both contain a value.
 
Thanks Rick. Works great!

Rick B said:
This is posted pretty often.

You use something like...

=([City] + ", ") & ([State] + " ") & [Zip]

The "+" will only print the items if both contain a value.

--
Rick B



Jan said:
I have a members DB and some members have alternate addresses. I have
fields
for address, address1, etc, and then addresssecond, citysecond,
statesecond,
etc. If the second address data doesn't exist, the report shows a , (see
paste below) for the citysecond, statesecond zipsecond etc.:

Ms. Jan
Web Editor
This Company
Park Avenue
Anytown, IL 12345 USA
(e-mail address removed)
,
Date Appointed:
Date Accepted:

Since Trim doesn't work for the comma combining these fields, what is the
code to delete this line?

Thanks
Click to expand...
Click to expand...
 
Back
Top