Notes for using Access to query to perform computation in queries
Notes for using Access to query to perform computation in queries
3. Use cross-table queries to compare a set of data
Create a query, select the "cross tabulation query wizard", and then select "Fleet transportation query". In the preceding dialog box, select the "driver" field as the line title from the available fields. Click Next.
Then, select "goods category" from the field as the column title. Click Next.
Select the "net weight" field, select "sum" for the function, and name the cross table query. The Wizard ends.
Is the design view of the generated query. The following table shows the query results of the cross tabulation, which clearly compares the quantity of each driver transporting a variety of goods. Team Transportation query-cross table driver waste rock powder ore other total Li Dafang 170.001715.4013.50310.002208.90 Wang chic 18.50922.3015.9021.30978.00 Zhang cute 310.001601.9094.20340.002346.10 Zhao Meituan
