MS Access... Duplicate records appearing now

[Ecniv]

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?

[seenu_1st]

see this link, may be useful

[Ecniv]

Hi thanks for the link, but I already know how to get duplicates out...

What I meant was that I ran a duplicate query - and it returned nothing. Then this week I run it and I get loads, but they all appear to be from 2011, so should have appeared before. So I was just asking whether anyone had this before.

Nice link though, worth a read.

[seenu_1st]

sorry , i dont hav any experience in this kind.