Sorting a Report column

[Guest]

I am trying to do an ascending sort on a column of numbers ranging in value
from 1 to 18. The numbers come out with what appears to be an ASCII sort.
How can I get them to sort from 1 to 18 in numerical order? Thanks
Arnold

 

[Guest]

Hi Arnold,

Is the underlying data type text or numeric? If it is text, you can try
using the VAL function.

Sorting in reports is controlled by accessing View > Sorting and Grouping,
from within report design. Sorts applied to a query are not used by a report.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Arnold:

It sound like the values are of text data type. If so include a computed
column in the report's underlying RecordSource which returns the numeric
value by means of the Val Function, e.g.

SELECT *,
VAL(YourNumberColumn) AS SortColumn
FROM YourTable;

and sort the report (not the query) on the SortColumn.

Ken Sheridan
Stafford, England

 

[Guest]

Thanks to Ken and Tom. Foregot that one.
Arnold

Arnold:

It sound like the values are of text data type. If so include a computed
column in the report's underlying RecordSource which returns the numeric
value by means of the Val Function, e.g.

SELECT *,
VAL(YourNumberColumn) AS SortColumn
FROM YourTable;

and sort the report (not the query) on the SortColumn.

Ken Sheridan
Stafford, England