Unique Pairs

[wellsw]

I have a table with to: and from: locations as below
to: from:
chi stl
det chi
stl Chi

What I need to do is create a list of unique pairs where chi stl is the same as stl chi. It doesn't matter which instance I keep only that they are unique pairs.


Any Ideas would be greatly appreciated.

Thanks

[JoeM]

I would create a query, where you sort the two entries on each line, and then do an Aggregate Query to weed out all the duplicates.

Assuming your table name is "Table1" and your field names are "to" and "from", the SQL code of that query would look something like:

SELECT IIf([to]<[from],[to],[from]) AS Entry1, IIf([to]<[from],[from],[to]) AS Entry2
FROM Table1
GROUP BY IIf([to]<[from],[to],[from]), IIf([to]<[from],[from],[to]);

[wellsw]

Worked perfect.. thank you very much.