Negative Numbers

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
 
R

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
 
R

Rick B

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
 
M

Michel Walsh

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
 
Top