Erik and Hugo,

Thank you so much for your help, the queries are brilliant and have helped me identify erroneous records.

Unfortunately I only have read only access to the tables in question and cannot make any changes to them. Also unfortunately, I have no input (excuse the pun) on the front end where the data gets captured. The sad thing is, looking at the results, there are very new (recent) records, that tells me the validation is poor. (i.e. I was hoping it was maybe only old data).

I report on the data and, as can be imagined, this causes duplicate data in the reports.

Thank you so much, you have helped me immensely.

Michael