query sort

[rsi]

when my query comes back with quote number, i have it set to sort the query
by the quote number (ascending). problem is that it sorts it but only by
the first number in the quote value. 1152, 11345, 2403, 300

obviously thats not right, so if anyone has any ideas i would really
appreciate it.

joe

 

[rsi]

thanks that worked perfectly!!!

Your quote number must be a text and not a number field
right? If so then Access is working correctly. Text is
sorted left to right and numbers are sorted as values. If
you are sure that field is only numbers then in a query
you can try adding this field and sort it:
SortQuotes:cdbl([QuoteNum])

note: If there are only long intergers (no decimals) then
use clng instead of cdbl

-Cameron Sutherland