increment the counter for each category

Posted on 2009-12-23
Last Modified: 2013-11-28
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.
Question by:rwamuhire
    LVL 12

    Accepted Solution

    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...)
    LVL 3

    Expert Comment

    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



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now