I have a string field "BoxNo" that has a mix of numbers and text. I.e. "5" and "Bulk". I need the highest number from the field.
Without any conversion it always returns say 9 rather than 10, with "9" being a higher ansi character than "1"
I am using the dmax function but can't get the syntax right.
My basic query is "Me.txtBoxNo = DMax("val(""boxno"")", "All", "[family]")"
I have tried all the variations between Val and boxno that I can think of but always get the error "Syntax error in expression"max(val("boxno"))".
As always, any suggestions greatfully accepted.
Without any conversion it always returns say 9 rather than 10, with "9" being a higher ansi character than "1"
I am using the dmax function but can't get the syntax right.
My basic query is "Me.txtBoxNo = DMax("val(""boxno"")", "All", "[family]")"
I have tried all the variations between Val and boxno that I can think of but always get the error "Syntax error in expression"max(val("boxno"))".
As always, any suggestions greatfully accepted.