# Compare two tables and find records without matches

• 11-12-2019, 06:03 AM
Isaacliu
Compare two tables and find records without matches
Dear expert

Can any expert help to create an access. I am a beginner of using access, hope you can help me.

I would like to create two table, Table A and Table B

Table A:

N1: Number, no decimal palce
N2: Number, no decimal palce
N3: Number, no decimal palce
N4: Number, no decimal palce
N5: Number, no decimal palce

Example
N1, N2, N3, N4, N5, N6, N7
1, 2, 3, 4, 5, 6, 7
2, 2, 3, 4, 5, 6, 7

Table B:
Date: 1/11/2019
remark: Text
N1: Number, no decimal palce
N2: Number, no decimal palce
N3: Number, no decimal palce
N4: Number, no decimal palce
N5: Number, no decimal palce

Example
Date, Remark, N1, N2, N3, N4, N5, N6, N7
1/11/2019, abc, 1, 2, 3, 4, 5, 6, 7
2/11/2019, def, 2, 2, 3, 4, 5, 6, 8

When running the queries, Compare two tables and find records without matches

Result:
N1, N2, N3, N4, N5, N6, N7
2, 2, 3, 4, 5, 6, 7

Use table B to find out the records without matches in Table A, many many data in table A.

Sorrry for my poor english and thank for all expert help here. Thank you very much.
• 11-14-2019, 11:01 PM
Isaacliu
Re: Compare two tables and find records without matches