Best method to compare 2 tables and highlight field differences

[warrensalsa]

I am new to MS_Access and am therefore looking for 2 pieces of advice on the below. The first is; what is the best design/methodology to use for what I want to do, and then second I need some step by step advice on how to achieve this.

I have 2 tables:

TabClient1
ID Name RGEnum tduop
1234 Homer 0987652 sdfd
1235 Homer 7652316 rthh
1236 Homer P234777 ruiu
1781 Madge GHJ887 ghjk
1782 Madge KLL909 ghjr

TabClient2
ID Name RGEnum post
1234 Homer 0987652 12DDE
1235 Gomer 7652316 67JGH
1236 Homer P234887 909UI
1781 Madge GHJ887 097HGT


1782 Madge KLL909 99OPO

Essentially I want to compare the two table and produce a comparison table with all entries, but highlighting the differences somehow eg in this example the names 'Homer' and 'Gomer' are different, as are 2 of the RGEnums.

I want something like this in the end:
ID NameTab1 NameTab2 RGEnumTab1 RGEnumTab2 tduop post
1234 Homer Homer 0987652 0987652 sdfd 12DDE
1235 Homer Gomer 7652316 7652316 rthh 67JGH
1236 Homer Homer P234777 P234887 ruiu 909UI
1781 Madge Madge GHJ887 GHJ887 ghjk 097HGT
1782 Madge Madge KLL909 KLL909 ghjr 99OPO

I have no idea what is the best way to do this so all help is greatly appreciated.

[June7]

These tables have a 1 to 1 relationship?

Build a query that joins the records on the common ID fields. Use this query as the RecordSource for a form or report. Use textbox Conditional Formatting to 'highlight' differences.

[JoeM]

You can use Conditional Formatting on your Report to do that.
See: https://support.office.com/en-us/art...5-44e43b05e22f

EDIT: Looks like June beat me to the punch here!