Hi,

Used this forum with great success when it comes to Excel.
Now I have started to learn Access and my first challenge is as following:

I have two tables that are more or less similar. I would like to know what the difference (textual) is between table 1 and table 2.
I am fairly new to Access, but I assume that I need to set up a query for this?
If possible it would be great if the differences between the tables where shown in a new table.

The ID field is not the same on the two tables.
In table 1 the ID is p001,p002,p003,etc - in table 2 the corresponding rows is IDīd s1,s2,s3,etc.

Any inputs to help me understand how to compare these two tables and have the differences as an output is greatly appreciated!