Strange Number Sorting Problem! Help needed!

[mohsinhq]

hi,

I have a couple of queries which churn out some sales figures based on customer.

The output query is descended by sales - so presumably the highest sales are at the top. However - the query is oddly sorting by the first digit only making the results appear in a odd order.

e.g. 90 is followed by 9 and then by 89 etc

Please see picture for visual..

Thanks in advance for any help.

 

[allan57]

The field that you are sorting on looks as though it is defined as text

 

[maxmangion]

you need to change the datatype of your field to number

 

[mohsinhq]

Hi,

Thanks for your replies.

The field was defined as General number whereever it was mentioned.

I have fixed the problem by defining the field absolutely in the query by adding CDbl to the front of the field.

Problem solved!