Compare tables for unmatched data

[scout]

Thank you for you reply, thank you I will look into the normalization. for back round this was done originally on excel and thought access might be easier once the time had been spent building it...I have no experience of access just You Tube and this database. the one attached is just what I use to test, the full has 10 other tables and forms which each will have between 50-100 sets of data.

the reason for same data is just that is how the study was agree that data would have a three point check to ensure data quality.

[scout]

Thank you, yes is for data quality.

A report sounds easier for someone who is not an expert and think I will look into this as will more than likely end up been manually checked also.

appreciate the time to responded

[isladogs]

I've re-checked some old threads at AWF and found that although 16 joins does/did appear to be the limit for action queries, I was also able to exceed 16 joins on select queries:

I had forgotten that at the time I did some tests and like June found that the limit doesn’t always apply:

1. Two 'copies' of the same table as a self join - with 23 fields joined
2. 20 tables joined with single inner join to the main table

Both worked...though unsurprisingly the second wasn't very fast

See https://www.access-programmers.co.uk.../#post-1627279
I've asked for clarification from the Access team about the join limits