I need to create a report or query that will show the last step
completed in a process.
Here are the details
Part number serial no
Discription Date
10068206-302 0225 KIT READY CHECK 6/26/2007 6:32:06 PM
10068206-302 0225 KIT PARTS 6/26/2007 6:32:21 PM
10068206-302 0225 KIT Audit 6/26/2007
6:32:34 PM
10068206-302 0225 KIT Audit 6/26/2007
6:35:28 PM
10068206-302 0225 KIT Audit 6/26/2007
6:36:55 PM
10068206-302 0225 FIRST INSPECTION STEP 7/25/2007 8:16:55 PM
10068206-302 0225 FIRST TEST 7/31/2007 11:18:17 PM
10068206-302 0225 SECOND INSPECTION STEP 8/1/2007 2:01:20 AM
10068206-302 0225 FINAL INSPECTION 8/1/2007 2:02:32 AM
I would like the query to only return the last line. This is the last
step in the process. basically i need to show what the process
performed on all of our parts. This seems really really really simple
but i am drawing a blank. thanks for your help
KO