Shulou(Shulou.com)06/02 Report--

This article mainly introduces the example of access report grouping statistical output according to a certain field, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

To achieve the statistical output of the report grouped by a field, you need to set: the group footer of that field. Reason: grouping statistics are mainly displayed in the group footer section, which is realized through the text box; when printing out, the data is displayed at the end of each group.

The group footer section mainly displays the grouping statistical data, which is realized through the text box; when printing output, the data is displayed at the end of each group; so in order to realize the report group statistical output according to a certain field, it is necessary to set the field group footer.

The position and function of three groups of headers and footers in access report

1. Report header / footer: all the contents in the report header can only be output at the beginning of the report. It's usually at the top of the home page. Place the title of the report in a label control in a large font

Report footer: this section usually appears at the end of the report only after all the main sections and group footers have been output. You can output calculated summaries and other statistics for the entire report by arranging text boxes or other controls in the footer area of the report.

2. Page header / footer: 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 the data.

Page footer: the total content that generally contains a page number or control. The data display is arranged in text boxes or other types of controls.

3. Group headers / footers: group headers mainly arrange text boxes or other types of controls to output data information such as grouped fields.

(use the sort and Group property to set the group header / footer area to achieve grouping output and grouping statistics of the report. )

The group footer mainly arranges text boxes or other types of controls to display grouped statistics.

Note: group headers and footers can be used separately as needed.

The above is all the contents of the article "access implementation report group statistical output by a certain field". Thank you for your reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.