Negative Numbers

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hello,

When I put my results in Descending order the negatives
come first. Is there a way to stop that? Need Positive
numbers first..

THANKS
 
Descending order would imply that negatives come first since a negative is
smaller than a positive.

What is it you'd like to see?




Hello,

When I put my results in Descending order the negatives
come first. Is there a way to stop that? Need Positive
numbers first..

THANKS
 
I'm sorry, I misread your question.

When I sort descending, my numbers go in the order...

10
9
..
..
1
0
-1
-2




Are you sorting a number, or a text field?

Rick B


Descending order would imply that negatives come first since a negative is
smaller than a positive.

What is it you'd like to see?




Hello,

When I put my results in Descending order the negatives
come first. Is there a way to stop that? Need Positive
numbers first..

THANKS
 
Hi,


You are probably sorting a DECIMAL field. That seems a bug, see
http://support.microsoft.com/?id=837148. Another work around (than the one
mentioned in the article) seems to use:



ORDER BY Myfield>0 ASC, MyField DESC

rather than just

ORDER BY MyField DESC




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top