Inventory Reporting

T

TS

I need to create a report showing the following data from
the mail table.
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 with 2
subforms with the daily and total inventories, but that
doesn't seem to work. Any suggestions? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total column in Query 1
AT WITS END ON QUERY TOTAL 34
How to create a "point in time" calculation that is date stamped 1
combining queries into 1 8
3 queries into 1 8
Filtering a sub-query (back-end is MS SQL) 1
Access 2007 0
Help with query criteria 8

Top