max total almost working (1 Viewer)

I have a query that takes a text field and removes "#" leaving just a number
Number:Right([issue],Len([issue])-1)

Then I made another query trying to use the max total of this number, it works except for it is returning 8 as a max instead of 10. It's not seeing 8 as 08.

It seems like it is having to do with format so I tried
Format(Right([issue],Len([issue])-1),"Standard") but that did not make a difference.

The function right is returning a string, either use value to convert your string into a proper number...
Or prefix your string with a set number of zeros

Number:Right("0000" & Right([issue],Len([issue])-1), 4)