troubleshooting Question

How to get query to return one row for each unique part #

Avatar of HOTWATT
HOTWATTFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution87 ViewsLast Modified:
I had help on here creating a query using dlookup which worked great. Only issue I am having now is I need one row for every unique part #. Right now if the part exists in two separate locations it comes up as two separate rows. I am trying to figure out how to make those come up as one row. I have attached photos of the query and query details if anyone could help point me in the right direction!
Query.PNG
query-details.PNG
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 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 2 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