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.