Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2010
    Posts
    29

    Unanswered: Code to add Yes and N/A's

    I am trying to add the Yeses and N/A's in a query from my table. I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column. I also need to add the No's separately from the others. Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Brian62 View Post
    I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column.
    any chance you could share your query sql please?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2010
    Posts
    29
    I go t my answer from antoher forum. Here it is:
    Sum(IIf([Fieldname] In ("Yes","N/A"),1,0))

Posting Permissions

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