LUIS FREUND
asked on
QUERY TO GET THE EARLIEST DATE AND QTY and DESCRIPTION ASSOCIATED TO THE EARLIEST IN ACCESS
What I'm trying to do is get the earliest date from ON_DOCK_DATE field and on QTY_OPEN and DSESCRIPTION field get the qty associated to the earliest.
For Example:
PART DESCRIPTION QTY_OPEN MinOfON_DOCK_DATE
900-64009-505 SCREW 2 11/2/2017
900-64009-505 SCREW FAI 12 10/5/2017
900-64009-505 TEST SCREW 28 12/7/2017
I would want to only see:
900-64009-505 SCREW FAI 12 10/5/2017
Here is my Sql String:
SELECT DISTINCT tbl_PART.PART_NUMBER, tbl_PART.DESCRIPTION, tbl_PART.QTY_OPEN, Min(tbl_PART.ON_DOCK_DATE) AS MinOfON_DOCK_DATE
FROM tbl_PART
GROUP BY tbl_PART.PART_NUMBER, tbl_PART.DESCRIPTION, tbl_PART.QTY_OPEN;
For Example:
PART DESCRIPTION QTY_OPEN MinOfON_DOCK_DATE
900-64009-505 SCREW 2 11/2/2017
900-64009-505 SCREW FAI 12 10/5/2017
900-64009-505 TEST SCREW 28 12/7/2017
I would want to only see:
900-64009-505 SCREW FAI 12 10/5/2017
Here is my Sql String:
SELECT DISTINCT tbl_PART.PART_NUMBER, tbl_PART.DESCRIPTION, tbl_PART.QTY_OPEN, Min(tbl_PART.ON_DOCK_DATE)
FROM tbl_PART
GROUP BY tbl_PART.PART_NUMBER, tbl_PART.DESCRIPTION, tbl_PART.QTY_OPEN;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AWESOME! Thank you!
Open in new window
just copied / pasted 1st query into 2nd one...