Hello,

     I know we are having a table named “InitemsiteHistDay”, using this table is quick to calculate a warehouse daily receipt totals and shipped totals.
      However, for some reasons, we would like to count the worker’s work load by receipt documents and shipment documents, Like 
                           Receipt Total          Shipped Total        Date
Worker 1                   10                          20                      2023-5-1
Worker 2                   5                             45                     2023-5-2

       It would be easy if we count seperately,  like we count  the daily receipt docs in 1 inquiry And all daily shipment docs in the other inquiry.   Then we join them in a new report or excle.

      Just curious, is it possible that just use 1 Generic inquiry to fulfill the need?
I tried join  Receipt with Shipment  on   Receipt.Site=Shipment. site, receipt.date=shipment.date, receipt.User=Shipment.User, but it would bring duplicated data , not right.