Access using query
Updated: November 3, 2006 00:00:00 Author:
Assume that there is already a "Convoy Transport" table as shown in Table 1, with the "Driver, Cargo Category, Gross Weight, Tare" field. We will use it as the raw data and calculate and count the data through query. Table 1 Original fleet transportation table
driver Cargo Category Gross weight Tare weight Li Dafang other 75.00 25.00 Zhao Meili other 75.00 25.00 Zhang Keai other 150.00 50.00 Zhao Meili Essence powder 19.70 5.40 Zhang Keai Essence powder 20.70 5.40 Zhang Keai Essence powder 20.60 5.40 Zhang Keai ore 19.60 5.40 Zhang Keai Essence powder 20.60 5.40 Zhang Keai Essence powder 21.10 5.40 Zhang Keai ore 21.20 5.40 Li Dafang Essence powder 17.40 5.40 Zhao Meili Waste stone 120.00 40.00 Zhao Meili other 15.00 5.00 Li Dafang Waste stone 105.00 35.00 Zhang Keai Waste stone 105.00 35.00 Zhao Meili Waste stone 105.00 35.00
Related Articles
How to select a record before the specified date in Access?
How to select a record before the specified date in Access? ...2007-04-04Create free accounting date reports-1.4. Let reports process data between the beginning and end of the period
Establish free accounting date reports-1.4. Let the reports process data between the beginning and end of the period...2006-11-11The reason why the Access database is "cannot be saved; locked by other users" is
ACCESS' concurrency control is very bad. Remember to close the database after each operation.2009-03-03ACCESS Study Diary
ACCESS Study Diary...2007-03-03Solve the problem of grouping reports in Access
Solve the problem of grouping reports in Access...2006-11-11Access database uses SQL statement to add fields, modify fields, and delete fields
Microsoft's Access includes Data Definition Language (DDL) to establish delete tables and relationships. Of course, this can also be solved by DAO.2009-10-10Use INNER JOIN syntax to join multiple tables to create record sets
Use INNER JOIN syntax to connect multiple tables to create record sets...2006-07-07Chinese Access2000 Quick Tutorial-1.2 Create Tables with the "Database Wizard"
Chinese Access2000 Quick Tutorial-1.2 Use the "Database Wizard" to create a table...2006-11-11Migrating Access database to SQL Server
Migrating the Access database to SQL Server...2006-11-11Chinese Access2000 Quick Tutorial--1.3 Design Table in "Design" View
Chinese Access2000 Quick Tutorial--1.3 Design the table in the "Design" view...2006-11-11