Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Formula (2000)

    Can anyone tell me why this function will not work?
    =Sum([SumOfPostwkhrs])/(Count([Count],"2"))
    I have a field titled "Count" which contains values of 1 or 2. I want it to count only the 2 values.
    Is there another way to do this? Any insight would be much appreciated.

    Thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Formula (2000)

    Try

    =Sum([SumOfPostwkhrs])/Abs(Sum([Count]="2"))

    This assumes that Count is a text field. If it is a number field, use

    =Sum([SumOfPostwkhrs])/Abs(Sum([Count]=2))

    BTW Count is an unfortunate name for a field because it is also the name of a built-in function; it could easily cause confusion.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •