What needs to be set to achieve report grouping and statistical output by a certain field?

To realize the report grouping statistical output by a certain field, you need to set: the group footer of the field. Reason: The group footer section mainly displays group statistical data, which is implemented through text boxes; when printing, its data is displayed at the end of each group.

The operating environment of this tutorial: Windows 10 system, Microsoft Office Access 2019 version, Dell G3 computer.

The group footer section mainly displays grouped statistical data, which is implemented through text boxes; when printing, the data is displayed at the end of each group; therefore, to achieve grouped statistical output of the report by a certain field, you need Sets the field group footer.

The location and function of the three groups of headers and footers in the access report

1. Report header/footer: All content in the report header can only be output in The beginning of the report. Usually at the top of the homepage. Put the title of the report in a large font in a label control;

Report Footer: This section generally appears in the report after all detail sections and group footers are output. The last end. By arranging text boxes or some other controls in the report footer area of ​​the report, you can output the calculation summary and other statistical information of the entire report.

2. Page header/footer: The text or controls in the page header are generally output at the top of each page. Usually it is the column header used to display data;

Page footer: generally contains the page number or the total content of the control item. The data display is arranged in a text box or some other type of control.

3. Group header/footer: The group header mainly arranges text boxes or other types of controls to output data information such as group fields.

(Use the "Sort and Group" attribute to set the group header/footer area to achieve group output and group statistics of the report.)

The group footer mainly arranges text boxes or other types The control displays grouped statistics.

Note: Group header and group footer can be used separately as needed.

If you want to read more related articles, please visit PHP Chinese website! !

The above is the detailed content of What needs to be set to achieve report grouping and statistical output by a certain field?. For more information, please follow other related articles on the PHP Chinese website!