I suspect you could have visualized by just placing the query fields close together or concatenating them in a field for viewing, but intending to deal with them as separate fields. I believe I tried isladog's suggestion and did get the message that I could not delete from the specified tables.
I've commented recently in another post about how tough I find subqueries, especially since people seem to want some sort of difficult grouping or other such things (I was successful there). In your case, this seemed to be the only solution and the solution is even more complicated than the other one without being concatenated. My table is tblConcatSplitDel (even though the values ended up not being concatenated). Using the query wizard to find duplicate records, you get a query with a subquery anyway. This would give records with duplicates, but since you have 2 records exactly the same (end in zero) using that query in a delete query would delete both records. You did not address this from post 8.
Here is the sql to cover that off. It uses a second subquery to get the MIN of ISSUE. You can reverse that to MAX if it suits you better. If you have situations where neither is acceptable, then I wish you luck with that. NOTE: I had to change CODE in brackets to [CDE] in this post, otherwise the forum code tags get screwed up.
Code:
DELETE tblConcatSplitDel.CODE, tblConcatSplitDel.DTE, tblConcatSplitDel.Loc, tblConcatSplitDel.IND, tblConcatSplitDel.ISSUE
FROM tblConcatSplitDel
WHERE (((tblConcatSplitDel.CODE) In (SELECT [CDE] FROM [tblConcatSplitDel] As Tmp GROUP BY [CDE],[DTE],[LOC]
HAVING Count(*)>1 And [DTE] = [tblConcatSplitDel].[DTE] And [LOC] = [tblConcatSplitDel].[LOC]))
AND ((tblConcatSplitDel.ISSUE) In (SELECT Min([ISSUE]) FROM [tblConcatSplitDel] AS T WHERE T.CODE = tblConcatSplitDel.CODE
ORDER BY MIN(ISSUE) DESC)));
Hope that is what you need.