Hi,

This is a weird one and its irritating.


I have a query that returns duplicated vehicles from a table of vehicles based on a short chassis.

I have run this at various times to try and keep the vehicles table fairly clean, but I ran it today to get lots of duplicates. Not a problem, wade through and clear them up.

However, it is returning duplicated record that haven't been updated since 2011. And I've run this dup query several times this year.

The company upgraded to MS Office 2010 a few months ago... Doubt its attached to that.



Has any come across this before?