Select the Text controls and Debit and Credit field and modify their properties by setting Decimal Places to Zero and Format to Standard. (xi) Pick up a label control from tool box by click action and place at Report Footer section, at the area vertically below the column “Name of Accounts” and give the caption “Total”. Set its Text align property to Centre, Font weight property to Bold and Font Size to . (xii) Pick up a text control and place it at Report Footer section at the area vertically below Debit column.
Set its Record source property as expression given below : = Sum ([Query ]![Debit]) The expression is written by clicking at (...) to call the expression pane. The expression [Query ]![Debit] within Sum( ) function refers to Debit field of Query . (xiii) Pick up another text control and place it at Report Footer section at the area vertically below Credit column. Set its Record source property as expression given below.
=Sum ([Query ]![Credit]) The expression is written in the manner as it applies to sum of debit column. The expression [Query ]![Credit] within Sum( ) function refers to Credit field of Query . The report design prepared above is saved as Trial Balance by Design. The Trial Balance report design appears on the RHS of Database Window as object under Reports.
. . Designing of Trial Balance with Sorting and Grouping To design a trial balance with grouping and sorting of accounts, the following additional steps are required. (i) Copy the trial balance design as created above and paste it with different name say “Trial balance with Grouping”.
Open this copied report design for modification in design view to incorporate the grouping and sorting of accounts in trial balance report. Fig . : Window displaying sorting and grouping dialog (ii) Change the data source property of report design by right click at the top left corner of report design % click at properties % Choose Tab and set the Record source property as Query107. (iii) Modify the Record source of Text controls for sum of debit