Decending sort with positive numbers before negative

[Guest]

Using Access 2003.
Query with a column of amounts, field format number.
When I sort this column in descending order, the negative amounts is put in
the top before the positive numbers.

Example: 900, 500, -12, 40, -123, -10, 100

After descending sort it looks like this:
-10, -12, -123, 900, 500, 100, 40

How can I sort the column, so the result becomes:
900, 500, 100, 40, -10, -12, -123

???

Thanks in advance to anybody hwo can help me.

André

 

[Allen Browne]

Open the table in design view, and select the number field.
In the lower pane, what Field Size are you using?
If Decimal, Access cannot sort it properly.
You must use a different Field Size.

More info:
Incorrect Sorting (Decimal fields)
at:
http://members.iinet.net.au/~allenbrowne/bug-08.html