Cant get report to sort correctly
Posted: Tue Jul 30, 2002 1:58 pm
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______________