Hi Experts,
I need to create a query that will return me all the unique records based on few fields. I am gonna try to explain by example.
here is a table with few columns :
Table name : Contact
Fields name: Company, Address 1, address 2, City, State, district #
Company Adress1 address 2 city state distric #
abc 124 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #02
abc 123 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #03
the output will be
abc 124 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #02
abc 123 street 222 door Miami FL #03
I would like a query that will show me all the unique company based on the fields : company , address 1 and district#.
I am trying to figure out how many unique company exists in a single district and have each district unique company on their own table.
Can someone help me ?
Thanks