Merge Two Tables

C

cypherus

Hi,

I need to figure out what is the easiest way to do this is. I have
two tables that have the following columns:

TABLE 1
AcctNbr, GiftRef, Gdate, PayCode, Amt

Table 2
GiftRef, Amt, MotvCode, FundId

I need to merge the two tables with GiftRef being the common table
between them. I have exported the tables from MSSQL to Access and am
wondering what the easiest way to do this is. Is there an SQL Query
that can merge the two tables on export by GiftRef? Is it easier to
do this in Access now that I've exported the two Tables? Any help on
this would be awesome. Thanks.
 
J

Jeff Boyce

Open a new query.

Add the two tables.

Join them on the common field(s).

Select which field(s) you want displayed for output.

Run it.

When the query returns the records you want, export the query.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top