M
Michael Kintner
I am having a problem with this query.
I would like to show the latest product in all the tanks based upon the
latest date for that tank.
Table:
Tank Date Product
43 12/1/04 ABC
45 12/1/04 DEF
46 12/2/04 KLM
45 12/3/04 DEF
43 12/3/04 ABC
43 12/6/04 XYZ
Result would be:
Tank Date Product
43 12/6/04 XYZ
45 12/3/04 DEF
46 12/2/04 KLM
Can someone please help me. Thank you in advance!!!
Happy Holidays...
Mike
I would like to show the latest product in all the tanks based upon the
latest date for that tank.
Table:
Tank Date Product
43 12/1/04 ABC
45 12/1/04 DEF
46 12/2/04 KLM
45 12/3/04 DEF
43 12/3/04 ABC
43 12/6/04 XYZ
Result would be:
Tank Date Product
43 12/6/04 XYZ
45 12/3/04 DEF
46 12/2/04 KLM
Can someone please help me. Thank you in advance!!!
Happy Holidays...
Mike