troubleshooting Question

ACCESS Query

Avatar of taverny
taverny asked on
DatabasesMicrosoft AccessMicrosoft SQL ServerSQL
3 Comments1 Solution55 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros