T
TS
I need to create a report showing the following data from
the mail table. Fields in mail table are MailType,
DateRecd, QtyRecd, QtyProcessed. Working from a form
that asks for the report date requested, I want to be
able to take, for each type of mail, all mail rec'd less
all mail processed to date less the requested reporting
date which would be the starting inventory. Then for the
Days Inventory, I would like to show everything received
less everything processed for the requested reporting
date. And lastly, for the Ending inventory, I'd like to
report all mail recd less all mail processed up to and
including reporting date. It would show something like
this.
Type of Mail | Starting Inventory | Days Inventory |
Ending Inventory
Where starting inventory = all inventory < reporting
date; Days inventory = inventory the day of reporting
date; and Ending Inventory = Total all inventory.
I initially thought I could create a report showing the
starting inventory and then create two subreports, one
with the Days Inventory and the other with the Ending
Inventory, but that doesn't seem to work. Any
suggestions? Thanks.
the mail table. Fields in mail table are MailType,
DateRecd, QtyRecd, QtyProcessed. Working from a form
that asks for the report date requested, I want to be
able to take, for each type of mail, all mail rec'd less
all mail processed to date less the requested reporting
date which would be the starting inventory. Then for the
Days Inventory, I would like to show everything received
less everything processed for the requested reporting
date. And lastly, for the Ending inventory, I'd like to
report all mail recd less all mail processed up to and
including reporting date. It would show something like
this.
Type of Mail | Starting Inventory | Days Inventory |
Ending Inventory
Where starting inventory = all inventory < reporting
date; Days inventory = inventory the day of reporting
date; and Ending Inventory = Total all inventory.
I initially thought I could create a report showing the
starting inventory and then create two subreports, one
with the Days Inventory and the other with the Ending
Inventory, but that doesn't seem to work. Any
suggestions? Thanks.