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

Question

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.

Answer 1

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(*)>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;

Answer 2

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.

Answer 3

Access Combine Tables

Answer 4

In table view, you could precise-click on the column and enter a clear out in the text fabric container that pops up as area of the menu. click in the container and use prevalent clear out expressions to clear out the table information. some examples: <4333 ability below 4333. >4000 and < 4500 ability better than 4000 and below 4500. 4123 ability in basic terms 4113. If the postcode is a text fabric container then you definately could desire to positioned costs around the fee (even inspite of the incontrovertible fact that get entry to is powerful at guessing what you recommend. for example: < "4333" is below 4333 in alphanumeric words The sort of information returned for each clear out is shown on the backside of the reveal (you have have been given to scroll to the backside of the table to make certain the selection if it is better than say one hundred information).