Problem with sorting on fields

[stevengeus]

Can someone help me?____I want to sort records in my report based on this formula: iif(recno()=1,1,iif(left(Description,3)="---",Sort1+1,Sort1))____The problem is that the value of Sort1 changes during the report____I also tried to make a total field of this, but without succes... ______Is there a solution for my problem?

[kfleming]

What do you want the order of the records to be?____Kathleen__R&R Support

[stevengeus]

Thank you for your fast reply!____Example:____---> Document ABC of 2008/07/08__Article ABC__Article CDE__Article EGG____---> Document CDE of 2008/07/15__Article FHR__Article PKH__Article KLM______In the report I want first to sort on my formula and second on a field ^article^__The meaning is that I can sort on the field ^Article^ within two times ^--->^, therefore I count the times ^---^ on my report____If you need more explanation, please let me know

[kfleming]

Can you simply use two sort fields.__The first would be a calculated field with the expression:____iif(left(Description,3)="---",subs(Description,15,3),"")____and the second would be:__iif(Description="Article*",subs(Description,9,3),")______Kathleen__R&R Support