Query comparing data in two tables

[KatyOftedahl]

Hello,

I am trying to figure out how to create a query that compares two tables in Access.

I have two tables set up with the same column types (data in the first table is for last week, data in the second table is for this week). I would like to compare these two tables and find out what (if any) data has changed.



Does anyone know how I can do this?

I can provide more information if needed.

Thanks in advance.

Katy

[ConneXionLost]

Hi Katy,

Which field(s) are you expecting to be different?

Also, which field(s) will serve as your key between the tables? (You need these to be the same so matched records can be compared.)

Cheers,