![]() To size the lines exactly, set their Width and Height properties in the Property Sheet. Use two lines at the top of the Year footer and three lines at the top of the Report footer section with the grand totals. Delete the label control.Īdd lines to the to the tops of each report section with subtotals. In the second EOMSale header, add a textbox with Control Source =Format(,“yyyy” “ Quarter ”“q”). Set its Control Source to =Year(), then delete its label control. To get the grouping and sorting in the proper order, use the dotted “grabber” to the left of the Sort, and drag it below the groups.Īdd a textbox to the first EOMSale header in the report layout. Choose EOMSale again, but this time set it to “by quarter,” “with a header section,” “with a footer section,” and “keep header and first record together on one page.” Set it to “with a header section” and “with a footer section.”Ĭlick Add a group again. Choose EOMSale, from oldest to newest, and by year. We want to group the report by year and quarter and then sort it by month.Ĭlick Add a group. Right now, the only thing there is the Sort by EOMSale. On the Design tab, click the Group & Sort icon to display the Group, Sort, and Total pane at the bottom of the report. Right-click on the object in the Navigation Pane and select Rename from the shortcut menu. This is different than our usual naming conventions for objects, so a good practice will be to rename the object. The title, Sales by Category, appears at the top of the report, but note that Access also used it as the name of the Report object. Change the report title to “Sales by Category.” Click Finish.Īccess will open the report. Set the layout to Tabular, then click Next. We will leave this blank for now, so click Next to move on to the sort order. The second step asks if you want to add any grouping levels. Select the last field in the Selected Fields list (Wind), then double-click SumAmount from the Available Fields to add it at the end of the Selected Fields. Then double-click SumAmount to move it back to Available Fields. Use the double-arrow button to move all of the fields from the Available Fields list to the Selected Fields. If the qSalesCrosstab query isn’t selected in the Tables/Queries list, use the dropdown to choose it. The first step of the wizard asks where fields will come from. From the Create ribbon, choose the Report Wizard command. Select the qSalesCrosstab query in the Navigation Pane.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |