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
    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
    Events Banda Singh Bahadur's Martyrdom - An Eyewitness Account History of Sikhism Mar 26, 2015

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

Share This Page