Return Last Sting In Field

[#1]

Hi All,

I have this set of data

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries
AD	RS100202	1	925.00	0.00	0.00	0.00	0.00
AD	RS100202	2	925.00	0.00	0.00	0.00	0.00
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00
PI	RS100202	1	4585.00	0.00	0.00	0.00	0.00
PI	RS100202	2	4585.00	0.00	0.00	0.00	0.00
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00
TP	RS100202	1	1000.00	0.00	0.00	0.00	0.00
TP	RS100202	2	1000.00	0.00	0.00	0.00	0.00
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00

I wish to return the maximum Ver No and then the corresponding data with that row ( See Below ). I have used the MAX function in an expression to select the maximum Ver no. What expression can i use to return the string which corresponds with the rest of the data on the Max Ver No field?

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00

Thanks in Advance

Regards
James

[Miguel_Angel_Baeyens]

Hello James,

Try with MaxString() function instead of Max() function. That should work.

Regards.

[IAMDV]

Thanks Miguel - This is very helpful!