Problem with function?

[devxweb]

Hey, There's seem to be a problem in either my function or understanding the field in my table. Ok, in the attached file, kindly pls take time to import it and take a look. There is a field, EnrolmentNumber which I cant make sense of WHEN generating a new EnrolmentNumber. one example - 1112OA1482 - The first four numbers are generated by a function, the two middle are just letters from first name and last, and the last four numbers should be higher than the last one < this is where i have a problem. I use this fucntion for the last four numbers:

Right(DMax("[EnrolmentNumber]","tbl_Students"),4)+1



The problem is that the last four digits from that field the function gives is 1704, but actually its 1725. Now can you guys export.txtplease identify the prob...thanks

[June7]

The maximum value in that field is 1213YR1703 so the calculation result is 1704. If you want the maximum of the last four digits, swap the functions:

DMax("Right([EnrolmentNumber],4)","tbl_Students")+1

[devxweb]

The maximum value in that field is 1213YR1703 so the calculation result is 1704. If you want the maximum of the last four digits, swap the functions:

DMax("Right([EnrolmentNumber],4)","tbl_Students")+1

Oh Lord..Thank you June7