I am using the code:
SELECT a.[Unload Device], a.[Scanner Position], a.[Serial #], a.[Model], a.[Tested By], a.[Test Date]
FROM [Unload Inventory] AS a
WHERE (((a.[Test Date])=(Select Max([Test Date]) from [Unload Inventory] where [Unload Device]=a.[Unload Device])))
ORDER BY a.[Unload Device];
(Which I used in conjucntion with the code received by Jon K....Thank you)
to pull out the max date for entered scanner. What I want to do now is display the unload device # plus all three scanner positions for each unload device. I had it working earlier, but now it has crapped out on me, and I have lost the code that I had. Could somone please help me to display all three scanner positions for each unload device. I want to pull the max date for each scanner position for each unload device. I hope I have made thi clear enough. Thanks to all who help!
SELECT a.[Unload Device], a.[Scanner Position], a.[Serial #], a.[Model], a.[Tested By], a.[Test Date]
FROM [Unload Inventory] AS a
WHERE (((a.[Test Date])=(Select Max([Test Date]) from [Unload Inventory] where [Unload Device]=a.[Unload Device])))
ORDER BY a.[Unload Device];
(Which I used in conjucntion with the code received by Jon K....Thank you)
to pull out the max date for entered scanner. What I want to do now is display the unload device # plus all three scanner positions for each unload device. I had it working earlier, but now it has crapped out on me, and I have lost the code that I had. Could somone please help me to display all three scanner positions for each unload device. I want to pull the max date for each scanner position for each unload device. I hope I have made thi clear enough. Thanks to all who help!
