Hi all,
I have a field containing order numbers, I had to make it a text field to allow for orders that have multiple job#'s which the company likes to add a letter at the end 1234A, 1234B, 1234C. The problem I'm having now is that I need to have the highest # to assign it to the next order created. I have the following.
9587
9588
50501
50502
50503
My query using max thinks that 9588 is the highest number since its a text field. How can I get a maketable query to look at my field which is called jobno, find the highest value, and create a table with only that jobno which should be 50503. Thanks a million.