Sorting Negative numbers in reports

  • Thread starter Thread starter Mike T.
  • Start date Start date
M

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
 
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
Click to expand...

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...
 
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!
 
Back
Top