DMAX with Letters - Alphanumeric
Posted on 2006-07-13
I have a form where I have a control that calculates a DMax for a field in a table. This works fine and the current value is AT1372
I now need to create the next ID number which will be fed into the next episode that is entered into the database (the answer should be AT1373). Unfortunately I cannot get it to add another digit.
The textbox that I have created which gives the DMax have the following equation:
Textbox is called EPISODEmax
As I mentioned above this is working
I have tried NZ and also +1 outside brackets etc but it won't work. Is there a way of doing this or will the letters (AT) be preventing the calculation?