Sorting in an Access report

E

E.G.

I am trying to create a report based in a table. I want to sort the report
using a numeric field, but the result I get is that the the report is sorted
like the sorting field is a text one. For example the sorted result is 11104,
112, 11201,... How can I take the result 112, 11104, 11201, ...
Thanks
E.G.
 
R

Rick B

Is the field a numeric field in your table?

I think you can use the following in your sort box if you have the field
defined as text...


=val([SomeFieldNAme])
 
I

It is a numeric field.

Rick B said:
Is the field a numeric field in your table?

I think you can use the following in your sort box if you have the field
defined as text...


=val([SomeFieldNAme])




E.G. said:
I am trying to create a report based in a table. I want to sort the report
using a numeric field, but the result I get is that the the report is sorted
like the sorting field is a text one. For example the sorted result is 11104,
112, 11201,... How can I take the result 112, 11104, 11201, ...
Thanks
E.G.
Click to expand...
Click to expand...
 
I

It is a numeric field.

It is a numeric field.

Rick B said:
Is the field a numeric field in your table?

I think you can use the following in your sort box if you have the field
defined as text...


=val([SomeFieldNAme])




E.G. said:
I am trying to create a report based in a table. I want to sort the report
using a numeric field, but the result I get is that the the report is sorted
like the sorting field is a text one. For example the sorted result is 11104,
112, 11201,... How can I take the result 112, 11104, 11201, ...
Thanks
E.G.
Click to expand...
Click to expand...
 
D

Duane Hookom

If
- the field is numeric and
- you have applied to formatting in the query and
- you have selected the field in your sorting and grouping dialog
then the report should always sort correctly.

If it doesn't seem to sort correctly then I expect you don't meet one of the
requirements above.

--
Duane Hookom
MS Access MVP
--

It is a numeric field. said:
It is a numeric field.

Rick B said:
Is the field a numeric field in your table?

I think you can use the following in your sort box if you have the field
defined as text...


=val([SomeFieldNAme])




E.G. said:
I am trying to create a report based in a table. I want to sort the
report
using a numeric field, but the result I get is that the the report is sorted
like the sorting field is a text one. For example the sorted result is 11104,
112, 11201,... How can I take the result 112, 11104, 11201, ...
Thanks
E.G.
Click to expand...
Click to expand...
Click to expand...
 
Top