Microsoft access combine tables. I have no much access experience.?

The two tables are the same kind data but with some duplicates. I am thinking to combine it first, then delete the duplicates from the combine list. I have no prior experience using Microsoft access.

Microsoft access combine tables. I have no much access experience.?computer repair

If you want to AUTOMATE then here's what you can do. Create three queries:

Query1:

SELECT IDNO, First(Table1.NAME) as NAME

FROM Table1

WHERE IDNO In (SELECT [IDNO] FROM [table1] As Tmp GROUP BY [IDNO] HAVING Count(*)%26gt;1 )

GROUP BY IDNO;

Query2:

SELECT Table1.IDNO, Table1.NAME

FROM table1 LEFT JOIN Query1 ON (table1.NAME = Query1.NAME) AND (table1.IDNO = Query1.IDNO)

WHERE

ISNULL(Query1.IDNO);

Query3:

SELECT IDNO, NAME

INTO Table3

FROM Query2;

Microsoft access combine tables. I have no much access experience.?free antivirus

Lets say you have two tables Tab1, Tab2. You want to merge them.

1. Select Tab1. Right Click and select Copy.

2. Right Click on empty space in Table view, select Paste.

3. From options dialog, enter Tab2 as table and select last option ''Append Data to Existing Table''

You are done. Its as easy as this.

Then sort the table Tab2 on required columns to find duplicate records, then delete them.

name of italian

finction as one pc