Report subform add order by descending not working
Posted on 2008-10-27
I have a report that has a subreport.
Everything was fine until they wanted to change the sort order of the information in the subreport.
They wanted to have TR_CODE to sort in descending order. The TR_CODE can have CM, DM or " " in it.
I have tried the following and nothing seems to help - the table that feeds the subreport is [tempstatement detail] - I have gone back and forth on these two approaches.
1) I changed the record source to the following:
Select * from [tempstatement detail] order by tr_code desc;
No change here.
2) I created a query that the TR_Code was in descending order, when I ran the query it looked fine. Change the record source for the subreport to the query and no change
Can anyone help me with this ?