I just inherited a database whose primary customer entry
form has fields for both residential and mailing
addresses. The staff currently does double entry, entering
the residential addresses into the mailing address fields
in every record, despite the fact that the vast majority
of our customers  don't have separate mailing addresses.
It was set up this way in order to generate mailing labels
from the mail address fields.

If I have my staff stop entering the unnecessary
information in  the mailing fields, how do I create a
query or report that will pull the main address *except*
when a mailing address is prensent and in those records
pull the mailing address? Or is a resdesign in order?
(Seems like I read something once about putting mailing
addresses in a separate table...)

I don't know Access all that well but I know our current
setup is wasting both the capabilities of the application
and my staff's time. Any suggestions are appreciated.

hank