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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Records 6
Delete Query: Could not delete from specified tables 0
Need query to filter out duplicates based on another column 4
Query to show 2 records from each unique entry in a field 2
complex query to pull unique values 6
Unique Count 1
Parameter Query Won't Run 0
unique records Access 2003 2

Back
Top