I'm struggling with a reconciliation query

[Robert]

Hi

I'm new to access and have a really simple query on MS access which I'm struggling with.
How do I build a simple query that extracts all the differences between two tables and shows the results in a third table.
Please see the screen shot below.

Thanks so much for your help

[ranman256]

you could do what you showed above:
append table A to the 'report' table,
append table B to the 'report' table,
make a query ,Q1, to sum the columns from the report table,
then make Q2, using Q1 to show the difference.

[Robert]

Hi,

Sorry for being so stupid on this. Please pretend I know absolutely nothing about access...

I Have tried to replicate the excel process in access by creating data Table A, data Table B, results table and some append queries which I hoped would combine Table A and B into the results.
As you can see from the screen shots below the results table (screen 5) hasn't worked and only shows the table A results. How can I correct this?

Is there a combine query? When the results table does combine all data from table A and B, then do I run a query it to find the items in A not in B, items in B and not in A, and items which have the same ID but different sales values in each table?

Thanks


Screen 1


Screen 2


screen 3



Screen 4



Screen 5 (The results screen does not pull in all the data as I had anticipated ?)

========================================

[QUOTE=Robert;397084]Hi

I'm new to access and have a really simple query on MS access which I'm struggling with.
How do I build a simple query that extracts all the differences between two tables and shows the results in a third table.
Please see the screen shot below.

Thanks so much for your help[/QU

[pbaldy]

In SQL Server it would be easy with a full outer join. In Access you can Union together 3 queries. See here:

https://support.office.com/en-us/art...1-07061a1478f6

the full outer join bit.