Sorting Negative numbers on a Report

[rccline]

I am creating a report with Report Wizard using a query as a data source.

I would like to sort on a field which includes negative numbers. The report does not recognize the negative numbers.

Sorting on the number field, the report doesn't recognize that -128 < 1 or that -131 < -128

How do I create a report that sorts the negative numbers properly?

Example:
123
125
-128
130
-131
138
155


and not:

-131
-128
123
125
130
138

 

[dhookom]

Are these calculated values or a numeric data field?
Are you sorting in the query or report? Only in the report works reliably.

 

[rccline]

Yes, these are calcualted values.
Robert

 

[dhookom]

Set your sorting in the dialog with the expression:
=Val([YourCalcdField])

Duane
MS Access MVP

 

[rccline]

Duane:

Thanks for the help!