Want to summarize the monthly balance

The work done will be recorded on a daily basis, each day there will be multiple entries. Each transaction will enter Lot no and Lot no balance for each day.
enough to put the balance of each day want to collect the amount each day
such as

   Date  ,  lot number , Q'ty     , total received

1/9/2021 , 2108036 , 400
1/9/2021 , 2108037 , 400
1/9/2021 , 2108038 , 400 , , , , 1,200

2/9/2021 2108039 400
2108040 400
2108041 500 1,300

The Receive + Quoted column is the sum of all received fields.


The app is divided into multiple tables.

for example

There will be a table named 1. Header , 2.Name 9109ss , 3.9109ss_pay.
2 and 3 will link to Table 1. Headers.