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

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > [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

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

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page