Sort Order On A report

[sulee876]

I have a form with an option box that is generating the sort order for
a report. The code is below.

=Choose(Forms!TaskTracker2!sortby,
[bug_id],[project_name],[priority_name],[status_name],[emp_name])

It works fine, but the bug_id field is a sorting 1, 10, 11, 2. I
really need it to sort in numeric order insted of ASCII. Is there
anyway I can deal with this without messing up the sort order if a
field other than bug_id is selected from the option box??

 

[John Spencer]

I don't know for sure, but I would try the following.

=Choose(Forms!TaskTracker2!sortby,Val([bug_id]),[project_name],[priority_name],[status_name],[emp_name])

 

[sulee876]

Thanks, but I just tried that and it gave me the same sort results.
Seems like there would be a relatively simple solution for this.

 

[Duane Hookom]

Replace the [bug_id] with
Format([bug_id],"00000000000")

 

[sulee876]

Thanks, that worked. Putting chr([bug_id]) works as well.

I appreciate the help!