Hello All,
I have a table with two fields : Special , FundValue. There are some replicating records for special with the same value, I want to select the last record of these multiple values .
For example
Special Fundvalue
0000001 10000.00
0000001 10010.00
0000001 10009.00
0000002 10080.00
0000002 10090.00
0000003 10100.00
I want to create a query that gives me the next result
Special Fundvalue
0000001 10009.00
0000002 10090.00
0000003 10100.00
Is this possible?
Thanks in advance.