Sorting a query

[Andy B]

Hi all

I have a table. Most of the fields are number, decimal, fixed to 2 places.
There are negatives and positives in these fields. I have created a query to
display information from this table and another, linked by a unique account
number. When I sort the query manually, or from within the query window, on
any of these number fields I get very strange results. If I click A to Z the
order seems to go from the most negative number through to the least
negative number through to the lowest positive number through to the highest
positive number. eg. -1000, -1,1,1000. How can that be?

Thanks in advance.

Andy.

 

[Andy B]

Sorry, the last bit didn't paste properly!!
When I sort Z to A, the data shows -1,-1000,1000,1.

Andy.

 

[Andy B]

Hi

It's me again! I've discovered that if I change the field type from Decimal
to Double, it sorts fine.

Andy.