Hello everybody. I have a table that lists the serial number of a device along with a dozen or so different tests this device undergoes before being shipped to our customer. How can query a device by Serial Number and only have it display the field representing the latest stage of testing. The data type for each test is Date.
For example, because I never think my explanations make sense.
If I run the query and enter 3050 for the [SN], and it underwent [Test1] on 8/1/08 and [Test2] on 8/2/08 and [Test3] on 8/3/08...Is it possible to have the query return
SN Test 3
3050 8/3/08
I know my table structure could probably be better but this is the last day for the project, it needs to get done. Is there a way to do this? Thank you in advance everyone.
For example, because I never think my explanations make sense.
If I run the query and enter 3050 for the [SN], and it underwent [Test1] on 8/1/08 and [Test2] on 8/2/08 and [Test3] on 8/3/08...Is it possible to have the query return
SN Test 3
3050 8/3/08
I know my table structure could probably be better but this is the last day for the project, it needs to get done. Is there a way to do this? Thank you in advance everyone.
