how to combine name and address information from 2 databases

[Guest]

I have one older database with a list of clients and lots of other information.
I have a newer database with a list of clients and different information on
them.
I would like to combine the names and addresses so I will have one big list
from which to make mailing labels.

 

[Phillip Windell]

Import the tables (with the data) from the old database into the newer
database. Now with them all in the same database build your "queries"
according to what you want.

You can then also "normalize" the data, set table relationships, and get rid
of the redundancy of repeated information and make the whole thing more
efficient.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

 

[Guest]

o.k.
so first I make sure I have the two tables in my database.
Then you mention an append query.
I don't see the mention of append on my query menu.

 

[Guest]

I have combined my information into two tables in one database.
I am stuck on making the query.
I am obviously doing something wrong as I either end up with thousands more
names than I should, or no names at all.
jp

Import the tables (with the data) from the old database into the newer
database. Now with them all in the same database build your "queries"
according to what you want.

You can then also "normalize" the data, set table relationships, and get rid
of the redundancy of repeated information and make the whole thing more
efficient.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp
-----------------------------------------------------

I have one older database with a list of clients and lots of other information.
I have a newer database with a list of clients and different information on
them.
I would like to combine the names and addresses so I will have one big list
from which to make mailing labels.

 

[John Vinson]

I have combined my information into two tables in one database.
I am stuck on making the query.
I am obviously doing something wrong as I either end up with thousands more
names than I should, or no names at all.

If you want to combine the two tables "end to end" - that is, if there
are 500 names in one table and 600 in the other, to end up with 1100
names (less exact duplicates) - try a UNION query. See the online help
for UNION, it gives a pretty clear example.

Or, you can create an Append query to append the names from one table
into the other.

A Join query (which it seems you're trying) will join the two tables
"side by side", matching each record in one table with some or all of
the records in the other... a very useful type of query but not for
this particular task.

John W. Vinson[MVP]