| Manually Adding Grouping | | | | Page Footer) |
| 1. Create report and click on View | Sorting and | | | | 2. Use the same formula in the calculated field eg |
| Grouping | | | | =sum([Fieldname]*[Fieldname]) |
| 2. Select field/s you want to group on Keep together | | | | Set Default Print Margins |
| property- | | | | Tools | Options [General] |
| Yes – keeps together | | | | |
| With First Detail – keeps together and first record is | | | | Create a Page Break after Each Group |
| kept with group header | | | | Add a page break in the Group Footer |
| Printing Data in Columns | | | | OR |
| File | PageSetup [Columns] | | | | 1. Select the Group Footer and open Properties |
| Printing Data in Columns with a Heading that Spans | | | | [Format] |
| Columns | | | | 2. Set Force New Page property to After Section |
| 1. Create a report showing the data in columns and | | | | Display Parameter Values in a Report |
| delete the page and report headers and footers. | | | | 1. Create the parameter query and include the |
| 2. Save the report. | | | | parameters as fields in the QBE grid – use exactly |
| 3. Create another report with a header that spans the | | | | the same names eg [Start Date] as a parameter, |
| new report | | | | would be something like Start: [Start Date] as a field |
| 4. Insert the other form as a subreport into the detail | | | | 2. Create the report and use the fields wherever |
| section of this report and resize so that it fills the width | | | | appropriate in the report, eg form report title control |
| of the report. | | | | source may read: |
| 5. Format borders as required | | | | ="Customer Orders between" & " " & [Start |
| 6. Save the report. | | | | Date] & " " & [End Date] |
| | | | |
| Numbering Records in a Report | | | | Open Report Based on a Single Record Shown in a |
| 1. Add an unbound text box to the detail section of the | | | | Form |
| report | | | | 1. Create a report as usual |
| 2. In the properties for the text box, click on the data | | | | 2. Create a macro: |
| tab | | | | Action: Open Report |
| 3. In the Control source property enter =1 | | | | Report Name: Name of Report |
| 4. In the Running Sum property select Over all or Over | | | | Where condition: [fieldname] = |
| Group if the numbering needs to restart in each group. | | | | Forms![formname]![formcontrolname] |
| | | | Fieldname is the unique reference that identifies the |
| Starting Page Numbering on a number other 1 | | | | record |
| 1. In the footer add an unbound text box | | | | 3. Drag the macro onto the form |
| 2. Type the following into the text box =[Page]+the | | | | |
| number you want to start on -1 | | | | Empty Calculated Fields |
| | | | If some records show empty calculated fields this is |
| Include a Running Total | | | | because the calculated field value is Null. To covert |
| 1. Insert an unbound text box | | | | Nulls to zeros use the NZ() function.eg =NZ([Price])*.2 |
| 2. In properties [Data] Control Source property choose | | | | |
| the name of the field you want a running total for | | | | Column Headings in SubReports |
| 3. Choose Over All or Over Group in the Running Sum | | | | Page headers and footers will not print – put |
| property | | | | headings in report header. |
| | | | If the subreport goes over one page but headings in a |
| Grand Totalling a Calculated Field | | | | group header. |
| 1. Use the Sum() function in the Report Footer (not | | | | |