Cant get report to sort correctly

[Gerard_(Guest)]

I have following:__JMA file wich is main____JMA links to DET1 (which has a STOCKA field)__JMA links to DET2 (which has a StockB field)____I want the report to sort on The Stocka/StockB field which is a stock code____e.g.__JMA_cODE DET1 DET2__100 AAA__100 BBB__100 CCC__100 AAA__100 BBB________What I am trying to do is:__JMA_CODE DET1 DET2__100 AAA__100 AAA__100 BBB__100 BBB__100 CCC____I have set up a field MySort=Trim(Det1 = DEt2) but it is still not sorting correctly, even though the field is printing ok__How do I do this ? ____Regards,__Gerard______________

[kfleming]

What if you create a calculated field with expression:__STOCKA STOCKB____and use that as your sort field?____Kathleen__R&R Support