Sorting in an Access report

[Guest]

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.

 

[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])

 

[Guest]

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 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.

 

[Guest]

It is a numeric field.

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 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.

 

[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.

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 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.