Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Counting Tick Boxes.

Discussion in 'Information Technology' started by Tom Transfield, Jul 28, 2006.

  1. Tom Transfield

    Tom Transfield
    Expand Collapse
    Guest

    When you count tick boxes they are counted as -1. How do you convert the
    Minus numbers to positive numbers.

    I have read the Microsoft solution but is appears to only relate the Report
    footers.

    Is there a way to do it in the query design view some how.

    Kind regards.

    Tom Transfield
    From the land down under....
     
  2. Loading...

    Similar Threads Forum Date
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    Malaysia Malaysian 2013 Election - Vote Counting Underway Breaking News May 5, 2013
    No Counting Allowed in Gurmatt Jap Ji Sahib Dec 15, 2012
    Christianity Ye Olde King James Version, 400 Years and Counting Interfaith Dialogues Mar 27, 2011
    Will counting caste help to reduce inequality? Hard Talk May 11, 2010

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    You can multiply by -1 or ABS([YourCalculatedField]).

    "Tom Transfield" wrote:

    > When you count tick boxes they are counted as -1. How do you convert the
    > Minus numbers to positive numbers.
    >
    > I have read the Microsoft solution but is appears to only relate the Report
    > footers.
    >
    > Is there a way to do it in the query design view some how.
    >
    > Kind regards.
    >
    > Tom Transfield
    > From the land down under....
    >
    >
    >
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 26 Jun 2006 22:00:33 GMT, Tom Transfield wrote:

    > When you count tick boxes they are counted as -1. How do you convert the
    > Minus numbers to positive numbers.
    >
    > I have read the Microsoft solution but is appears to only relate the Report
    > footers.
    >
    > Is there a way to do it in the query design view some how.
    >
    > Kind regards.
    >
    > Tom Transfield
    > From the land down under....


    Using an unbound text control in a report:
    = Abs(Sum([CheckBoxField]))
    will return the count of how many boxes are checked (as a positive
    number).

    In a query:
    SELECT tblBasicData.CheckField, Sum(Abs([CheckField])) AS
    CountOfChecked
    FROM tblBasicData
    GROUP BY tblBasicData.CheckField;

    I would do it in the report.

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page