I am counting connections between 2 sites and have got routes in both directions i.e. London to Manchester and Manchester to London, which is giving me multiple connections between the 2 sites. How can I remove the duplicated set of sites considering that not all connections are duplicated in the 2 directions. I have this information in a table with colomns named A_Site and B_Site and Qty, I also have this table as a Crosstab Query with the site names running along the side and across the top and the Qty as the value. I have got the required connection qty in both directions so it doesn't matter which set I remove.

I would really appreciate it if anyone can help, I'm sure there is a simple solution I just can't find it.

Many Thanks
Sarah