Sorting Negative numbers in reports

[Mike T.]

I am trying to only see negative percents in a report, but
it isn't recognizing the negative numbers. How can I
either sort by these or search through the criteria in a
query?

Thanks,
Mike T

 

[John Vinson]

I am trying to only see negative percents in a report, but
it isn't recognizing the negative numbers. How can I
either sort by these or search through the criteria in a
query?

Thanks,
Mike T

Care to post the SQL of the query that's not showing the numbers? A
criterion of

< 0

should work, but I have no idea what you've tried...

 

[Mike T.]

My mistake. I went back to look at the table and that
field is currently marked as a text field so that's why <0
wasn't working. Thanks!