Compare an Updated Table

[mgiam89]

I have 2 tables with the same structure but some of the data in one field is different

The tables are called Current and New

They both share a field called feesch but in the new table data is updated


The tables have share the same primary key of unique ID


How can I make a query in design view to show the feesch records that don't match?

Thanks in advance

 

[JoeyY]

Have you tried running a 'Find Unmatched Query Wizard'?

 

[mgiam89]

Have you tried running a 'Find Unmatched Query Wizard'?

Yes I have manually found data that has changed and the find unmatched doesn't seem to pick it up

 

[JoeyY]

Oops,

I misread your post. I think this will work. If your field is [Current].[feesch], your criteria is

<>[New].[feesch]

 

[mgiam89]

I misread your post. I think this will work. If your field is [Current].[feesch], your criteria is

<>[New].[feesch]

Thank you worked like a charm!!!