• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

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 Solution
ioanePlanning & Analytics ManagerCommented:
Hi rwamuhire,

This is a common requirement.

In the footer of your report place an unbound text box for each summary count.

In the textbox (or in the ControlSource property) enter: =Count([Ordered]) , etc..
(Changing [Ordered] to the name of the field you want to summarize in each textbox i.e. [Backordered], [Out of Stock], etc...)
Let me know if this is any help:

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



Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now