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.
Bookmarks