Sort Order On A report

  • Thread starter Thread starter sulee876
  • Start date Start date
S

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