Sorting in an Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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])
 
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...
 
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...
 
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...
 
Back
Top