Access 2010 - 使用Union All和Sum Iif查询以生成多个表中特定事件的总计数/总和

I have a database with four tables: Table 1, 2, 3, & 4. Each table holds the following fields: ID (AutoNumber), Date (Date/Time), Name (Text), and Item (Text)I have a database with four tables: Table 1, 2,