Lets say I have a table called Table1 with the following columns/data.
ItemNumber, Value, ValueDate
0001, $10.00, 01/01/2005
0001, $20.00, 02/01/2005
1234, $15.00, 01/01/2005
1234, $30.00, 02/01/2005
As you can see each item may appear multiple times. What I need to do is get the total
value of all the items using the most current valuedate. In other words sum the most recent single value of each item.
Given the data above the result should be $50.00
Item 0001 @ $20 + Item 1234 @ $30
Thanks in advance
DnetMHZ
ItemNumber, Value, ValueDate
0001, $10.00, 01/01/2005
0001, $20.00, 02/01/2005
1234, $15.00, 01/01/2005
1234, $30.00, 02/01/2005
As you can see each item may appear multiple times. What I need to do is get the total
value of all the items using the most current valuedate. In other words sum the most recent single value of each item.
Given the data above the result should be $50.00
Item 0001 @ $20 + Item 1234 @ $30
Thanks in advance
DnetMHZ