Search results for query: *

Taking all fields into consideration, there are about 20 in the actual table, I can sort it so the first one in a group is the valid record.

Hello and thanks for taking your time to view this. I am hoping this is not a difficult request, merely one I have never had the need to explore yet. Difficult is even ok, impossible would be bad. Basically I have a large list of duplicate files. I found a way to sort them in such a way that...

No it will not, the any other object linking to that field will not be able to find it and generate errors. Unless someone knows a way to have access relink these. However until someone post this, I would not reccomend it unless you wish to manually recreate the links.

SELECT DISTINCTROW TABLENAME.ISSUEDATE, TABLENAME.ISSUEID FROM TABLENAME WHERE (((TABLENAME.ISSUEDATE) In (SELECT [ISSUEDATE] FROM [TABLENAME] As Tmp GROUP BY [ISSUEDATE] HAVING Count(*)>1 ))) ORDER BY TABLENAME.ISSUEDATE; In the above it is checking Issuedate for Dupes alone. You had stated...

Ok I want to thank you in advance, since this may or may not make a ton of sense. I am working with a databse that is riddled with dupes. However not all can be deleted, that's relatively normal of course. The tricky part I need a sssistance with is this. Lets say that there are 3 dupes found...