Group Header Sorting

[Guest]

I have a group header that I am using to sort data on a report. This header
references a text (string) field in my table/query. This field has a mixture
of some numbers and text in it. (Example:10A or 11-H or just 1 2 3 etc) So
what I want my report to do is sort the data by the number it finds first
(similar to the val function you can use in a query).

Here is what I am getting now for my order
1
10A
11-H
2
3

What I want is:
1
2
3
10A
11-H

Does this make sense and can it be done???

 

[Douglas J. Steele]

Use the Val function: add it as a computed field to the query, and then sort
on that field, rather than the original field.

 

[Guest]

Man I feel about stupid... It works, Thanks Douglas.