Hi,
I need to compare two sources and identify records that are not equal if one of the values in the record set is not identical to the same record in another source.
Source 1: Table A:
ID Kreditornr Land Sale
1 9000000 DK 1000
2 9000001 DK 2000
3 9000002 NL 3000
4 9000003 4000
5 9000004 DK 1500
Land is blank on record 4.
Source 2: Spreadsheet (linked table)
Kreditornr Land Sale
9000000 1000
9000001 DK 2000
9000002 NL 3000
9000003 DE 4000
9000004 DK 8000
Land is blank on record 900000.
Result: Changed records
ID Kreditornr Land Sale
1 9000000 1000
4 9000003 DE 4000
5 9000004 DK 8000
Land is blank on record 1.
How can I do this in a query? Later in the process I need to update Source 1 - Table A with the record set from the result query.
Hope you can help me
Best regards
Morten
I need to compare two sources and identify records that are not equal if one of the values in the record set is not identical to the same record in another source.
Source 1: Table A:
ID Kreditornr Land Sale
1 9000000 DK 1000
2 9000001 DK 2000
3 9000002 NL 3000
4 9000003 4000
5 9000004 DK 1500
Land is blank on record 4.
Source 2: Spreadsheet (linked table)
Kreditornr Land Sale
9000000 1000
9000001 DK 2000
9000002 NL 3000
9000003 DE 4000
9000004 DK 8000
Land is blank on record 900000.
Result: Changed records
ID Kreditornr Land Sale
1 9000000 1000
4 9000003 DE 4000
5 9000004 DK 8000
Land is blank on record 1.
How can I do this in a query? Later in the process I need to update Source 1 - Table A with the record set from the result query.
Hope you can help me
Best regards
Morten