Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Report subform add order by descending not working

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 ?
0
proffittware
Asked:
proffittware
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Remove in sorting from the query, and use the Grouping and Sorting dialog in the sub report to specify the sorting.

mx
0
 
proffittwareAuthor Commented:
I will try and get back
0
 
proffittwareAuthor Commented:
That did it.  Thanks...
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You're welcome as always.

Also note that ... anytime you do have anything specified in the Grouping and Sorting dialog ... Access ignores *any* sorting in the underlying query - which is then just a performance drain - since the query still sorts anyway - but the report only goes by what is in the G/S dialog.

mx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now