Displaying all of the same value from both tables?

[Bee*]

Hi, sorry if this has been covered before, I am a new guy around here.

I have two tables in a select query, both with a code field and a monetary value field. The codes are linked. This query is to show the variances in the values of each table as they are meant to have identical codes and values. However, each table has a small handful of codes that are not in the other, but all the query outputs is the variances for codes that are in "both" tables. I realise you can do one way relationships so that you can display all from one table and only those matching from another. However I need the query to show "all" the codes from both tables, and the value difference.

Any advice on going about this? Would be much appreciated! Thanks.

 

[neileg]

I think you may need to make three queries and union them together. One is the query you have. The second and third should pull the records from each table with no matching record in the other table.