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

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

Do more with

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

/gustav
HOTWATT

Author

Commented:
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