rwamuhire
asked on
increment the counter for each category
let's say the current status of my inventory is the following:
1. Ordered
2. Backordered
3. Out of stock
I would like to be able to do the following in the group footer for my report: for each category, increment the counter. in the end I would like to have something like:
Ordered: 2
Backordered: 12
Out of stock: 12
You help is greatly appreciated.
1. Ordered
2. Backordered
3. Out of stock
I would like to be able to do the following in the group footer for my report: for each category, increment the counter. in the end I would like to have something like:
Ordered: 2
Backordered: 12
Out of stock: 12
You help is greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have a table called Products that hold your ihventory information, then you should be able to specify table columns for Ordered (normal) plus Backordered or Out of stock. The quantity would be added to each column through a form and could be split across columns (for example, 300 widgets, 150 ordered, 150 backorderd)
Once you have these fields in place (UnitsOrdered. UnitsBackOrdered and UnitsOutOfStock), you can report on them in detail on a report or just in summary at the report footer. To create the report, make Products the source of the report and drag the inventory information onto the detail line (e.g. InventoryID. UnitsOrdered. UnitsBackOrdered and UnitsOutOfStock)
Once the fields are in the report, you can add Summaries to the footer by copying the fields (e.g. UnitsOrdered from the Detail line to the Footer. Dbl click on the field and change the source from UnitsOrdered to =Sum([UnitsOrdered]) and it will add up the entries in the Group. Do this for any field you want to summarize
Let me know if you have another setup and need additional information
Dave