query sort

R

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
 
R

rsi

thanks that worked perfectly!!!


Cameron Sutherland said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preferred way to do sort order - column in table, or specified in query? 3
Random Function for Selecting Records 6
Need help sorting a query 3
Why Query works from table but not Query 3
sort query with null values at end 2
calculated currency field sorts like text instead of numeric 4
Sort order by customer name not working in query 5
complex query to pull unique values 6

Top