Link to home
Start Free TrialLog in
Avatar of HOTWATT
HOTWATTFlag for United States of America

asked on

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

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
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HOTWATT

ASKER

Thanks that seems to have worked!