Welcome to SPN

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

Sign Up Now!

Re: Group count query advise

Discussion in 'Information Technology' started by Dirk Goldgar, Jul 28, 2006.

  1. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:eDkwe2qcGHA.636@TK2MSFTNGP05.phx.gbl
    > [X]='A' will return -1 (True) if the value of X is currently A, and 0
    > if it isn't.
    >
    > Sum([X]='A') will sum all of those -1 and 0 values.
    >
    > Abs(Sum([X]='A')) will convert the sum of -1 values to a positive
    > number. That value represents how many of the [X] values were equal
    > to 'A'
    >
    > (note that Dirk inadvertently left out the final closing parenthesis
    > in the original expression)


    Thanks for catching that, Doug.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  2. Loading...


Share This Page