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

HOTWATT used Ask the Experts™
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!
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Remove the checkmark from ML_Location and mark the property of the query to return distinct values only.



Thanks that seems to have worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial