Seemingly Double Values to be deleted

[MrDummy]

Hello,



I am gaining more and more experience in Access however I have come across the following issue which I haven’t been able to solve yet.
In a selection query I have the following result in one field:

1 9876 Combined with 2345
2 2346 Separated by 1234
3 6534 Issued by 2569
4 1234 Separated by 2346
5 5634 Issued by 9346
6 2345 Combined with 9876
7 3273 Boarded by 9346

Is this field the records 1 and 6 are the same and records 2 and 4 are the same; the numbers have only changed position from back to forth. The number always consists of four characters. I want to exclude these seemingly “double values” from the list and the result must be:

1 9876 Combined with 2345
2 2346 Separated by 1234
3 6534 Issued by 2569
5 5634 Issued by 9346
7 3273 Boarded by 9346

Question is: Do you have an idea how to remove these double values.

[ranman256]

Data-wise they are not duplicates, but

but you could locate them by start a query,
bring in the table twice, join the second fld with the last fld,

and the two 3rd flds.

[MrDummy]

Ok thanks will give it a try.
Output is a query with one field with 7 records. The records are variable in number and output and are therefore not always like this. It varies with the input if the user.

However will give it a try.

[MrDummy]

No luck so far. Any Iseas becasue I am pretty much stick!