I created a quick table with a Text field named 'Test' in which I put the numbers 1 - 15.
Then I created a query with this SQL:
Code:
SELECT Max([Test]) AS Max_ID
FROM Table3
Where cint(Test) < 10;
The CInt function converts the Text representation of a number into an actual number.
The query returns "9".
I think when you have a field that is going to display numbers - it should be defined it in the table as Numeric.
It just saves contortions like using the CInt() finction in the query.
Still - I hope this helps!!
Let me know if if this doesn't work for you.