Merging two FIELDS in Access?

[bmcgeoch]

Our firm had our database created by our technical support provider. They
did an excellent job and addressed all of our needs. However, what we have
found is that we need only one address (for both home and work), instead of
having fields for both. I'd like to save myself the trouble of manually
transposing each home address to business address, if possible.

We have two types of people in our database, referring attorneys and
clients. We have the clients' *home* contact info, and the referring
attorneys' *business* contact info, and very few entries for which we have
both. I'd like to merge either the home info for clients into the
corresponding blank cells for, or vice versa. Is this possible?

 

[bmcgeoch]

Wow! Your advice was spot on! Thank you so much.

But I have one last question regarding the use of the Select Query and the
Parameter Value. What should I input for each, [HomeAddress] and
[CompanyAddress]?

Hi -

You can easily do this with update queries. Just set the [home address] =
[business address] where the home address is Null (blank) in one query, and
do the opposite in the other query. In SQL it would look something like this:


Update [AddressTable] set [home address] = [business address] where [home
address] is null;
or
Update [AddressTable] set [business address] = [home address] where [business
address] is null;

You can then delete one of the address fields. Before doing so, though, you
will need to look for the "very few" records which have two different
addresses, and decide which one you want to use. A select query which has
[home address] <> [business address] in the criteria will find these for you.

John

Our firm had our database created by our technical support provider. They
did an excellent job and addressed all of our needs. However, what we have
found is that we need only one address (for both home and work), instead of
having fields for both. I'd like to save myself the trouble of manually
transposing each home address to business address, if possible.

We have two types of people in our database, referring attorneys and
clients. We have the clients' *home* contact info, and the referring
attorneys' *business* contact info, and very few entries for which we have
both. I'd like to merge either the home info for clients into the
corresponding blank cells for, or vice versa. Is this possible?