G
Guest
I don't know the best way of asking this question, but here goes...
I have a primary data table that looks something like this:
Serial Number Date testvalue
0001 2/25/06 1000
0001 2/25/06 1234
0001 2/27/06 5675
0015 2/24/06 1534
0015 2/26/06 9521
0027 2/24/06 1699
0027 2/25/06 8640
Each serial number appears multiple times but with different testvalues. I
want a query that returns each serial number only once and with the maximum
of the test value for that serial number. Based on the above data the
desired result would look like:
Serial Number Date testvalue
0001 2/27/06 5675
0015 2/24/06 9521
0027 2/25/06 8640
How can I do this?
Rob
I have a primary data table that looks something like this:
Serial Number Date testvalue
0001 2/25/06 1000
0001 2/25/06 1234
0001 2/27/06 5675
0015 2/24/06 1534
0015 2/26/06 9521
0027 2/24/06 1699
0027 2/25/06 8640
Each serial number appears multiple times but with different testvalues. I
want a query that returns each serial number only once and with the maximum
of the test value for that serial number. Based on the above data the
desired result would look like:
Serial Number Date testvalue
0001 2/27/06 5675
0015 2/24/06 9521
0027 2/25/06 8640
How can I do this?
Rob