Can't get record sort to sort sequentially 1

[cjbrown815]

I have two fields SAMPLE.TEXT5 (the facility) and SAMPLE.REMARKS (the sort order) the data in the

Group 1
SAMPLE.TEXT5 is
Brownsville IP
Newtown
Newtown 1
Juna IP

Sort by
SAMPLE.REMARKS
WS 1
WS 11
WS 10
WS 2
WS 3
WS 4

I created a formula field called{@Sort Field}

Formula
SAMPLE.REMARKS + SAMPLE.TEXT5

I need to group by facility, but sort by SAMPLE.REMARKS.

I'm getting
WS 1
WS 11
WS 10
WS 2
WS 3

How can I get the sort in proper sequence?


thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

What IS the proper sequence? Do you want the numeric text treated as a number? Then use the following for your sort field:

Left({sample.remarks},3)+ totext(val(mid({sample.remarks},4)),"0000")

-LB

 

[cjbrown815]

You are a master!! Thank you

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931