 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Sorting for report and subreport
I have a report that contains a subreport. The report is a query that pulls records by entering a fiscal year. The main report has four fields: Rank - this field is a running sum Project # Project Title Fiscal Year The subreport named (Combined) has a calculated field: Score Project # The two reports are link by Project #. I need to sort the calculated field (Score) which is in the subreport in descending order. How do I accompish this? Please help!!!! TB Which report do you want to sort? What is the calculation for Score?  SignatureDuane Hookom MS Access MVP -- >I have a report that contains a subreport. The report is a query that pulls > records by entering a fiscal year. [quoted text clipped - 16 lines] > Please help!!!! > TB I want to sort the subreport. The calculation for "Score" comes from two tables - Tech scores and Grant scores. Tech scores (Table) Question1 Question2 Question3 Grant scores(Table) GCQuestion1 GCQuestion2 GCQuestion3 The calucation is computed in the report and not in the table - so the end result is not stored anywhere. The calucation is as follows: Question1 + Question2+Question3=Total GCQuestion1+Question2+Question3=GCTotal Total + GCTotal = Score (which is the field in the subreport that I want to sort in descending order.) > Which report do you want to sort? What is the calculation for Score? > [quoted text clipped - 18 lines] > > Please help!!!! > > TB You can't sort a report on values calculated in the report unless you can calculate them in the report's record source. You can use expressions in your Field/Expression for sorting and grouping like: =[Quantity] * [UnitPrice] - [DiscountAmt] You may be able to use: =Question1+Question2+Question3+GCQuestion1+Question2+Question3 This assumes none of your field values are null. SignatureDuane Hookom MS Access MVP -- >I want to sort the subreport. The calculation for "Score" comes from two > tables - Tech scores and Grant scores. [quoted text clipped - 43 lines] >> > Please help!!!! >> > TB |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.