How to extract unique records based on two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that has 3 columns as follow:

Origin
Net Weight
Destination

Now when I do "Unique values" it gives me the unique records based on all of
the above 3 combination. What I really want is it should be unique on the
basis of "Origin" and "Destination" only.

Can some one advise how to go about doing that, I want to get a different
Origin and a different destination each time the Net weight could be same.

Thanks in advance!

MSA
 
Are you saying you only want to see Origin and Destination, and see the
unique combinations of those two? As soon as you add in Net Weight, each
pair of Origin/Destination could have more than one Net Weight, right?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top