Welcome to SPN

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

Sign Up Now!

Count If

Discussion in 'Information Technology' started by Steve, Nov 18, 2005.

Tags:
  1. Steve

    Steve
    Expand Collapse
    Guest

    Is there a way, (on a report), that I can count only the original records.
    For example, the starting contract is "00" the subsequent modification start
    at "01" and go up. I have created a report showing all contracts and
    modifications but I only want to count the originals. I still want to show
    the modifications but only want to cont the originals.

    Thank you in advance for and help

    Steve
     
  2. Loading...

    Similar Threads Forum Date
    What Counts As "sangat" To You? Interfaith Dialogues Mar 15, 2017
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    Wolf Count Blogs Oct 17, 2015
    Recount Blogs Oct 17, 2015

  3. OP
    Dean

    Dean
    Expand Collapse
    Guest

    One way to do this is to create an expression using the ImmediateIF function
    (IIF), iif(contract=00,1,0) then create sum expression in the footer that
    sums the results of the expression.

    "Steve" <Steve@discussions.microsoft.com> wrote in message
    news:C0957300-C90E-42E7-A9F4-A44EA9F2C959@microsoft.com...
    > Is there a way, (on a report), that I can count only the original records.
    > For example, the starting contract is "00" the subsequent modification
    > start
    > at "01" and go up. I have created a report showing all contracts and
    > modifications but I only want to count the originals. I still want to show
    > the modifications but only want to cont the originals.
    >
    > Thank you in advance for and help
    >
    > Steve
     
  4. OP
    fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 17 Nov 2005 10:29:12 -0800, Steve wrote:

    > Is there a way, (on a report), that I can count only the original records.
    > For example, the starting contract is "00" the subsequent modification start
    > at "01" and go up. I have created a report showing all contracts and
    > modifications but I only want to count the originals. I still want to show
    > the modifications but only want to cont the originals.
    >
    > Thank you in advance for and help
    >
    > Steve


    =Sum(IIf([YourField] = "00",1,0))
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page