2. The calculation of grouped data with a select query
Create a Select query, add "fleet transport inquiries", and drag the "Driver, cargo category, net weight" field to the design grid. Click the Totals button on the toolbar
, the total row is added to the design grid. As shown in the figure of the driver and Cargo category column set to "Group by" (to remain unchanged), the Net weight column is set to "sum", meaning that the driver and the category of goods in the group to sum the total weight of the calculation. The resulting query effect is shown in the following table: queries grouped by driver and cargo category
Driver Cargo category Transport Total Li Dafang waste stone 170.00 Li Dafang fine powder 1715.40 Li Generous ore 13.50 Li generous other 310.00 king chic waste stone 18.50 King chic fine powder 922.30 King Natural and natural 15.90 King Natural and unrestrained other 21.30 Zhang Lovely stone 310.00 lovely fine powder 1601.90 Lovely ore 94.20 lovely other 340.00 Zhao beautiful waste stone 790.00 Zhao Beautiful fine powder 1537.40 Zhao Beautiful ore 21.60 Zhao beautiful other 420.00
