Page 3 of 3 FirstFirst 123
Results 31 to 38 of 38
  1. #31
    shak2 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    23
    It would count the same way. I want a count of yes for each field regardless of the selection in the others.

  2. #32
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    if all fields are "YES/NO" fields, you can do sums on each field. because YES = -1, NO=0. the sum equal number of YES , in negative.

  3. #33
    shak2 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    23
    hmm.....i'll try it

  4. #34
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    If you want to be really tricky you can even multiply the final result by -1 to get the value as a positive number... shocking, I know...

  5. #35
    shak2 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    23
    hmm....and there's absolutely no way to do it in Access? This is a large database. Having two forms makes it a bit more complicated.

  6. #36
    shak2 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    23
    Quote Originally Posted by slave138 View Post
    If you want to be really tricky you can even multiply the final result by -1 to get the value as a positive number... shocking, I know...
    And There's no need to be snippy!

  7. #37
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    Quote Originally Posted by shak2 View Post
    And There's no need to be snippy!
    Wasn't trying to be... just figured I was stating the obvious.

  8. #38
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    We are talking about doing it in Access. Not Excel.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Counting multiple items in a query
    By slaterino in forum Access
    Replies: 2
    Last Post: 10-14-2010, 08:21 AM
  2. Replies: 4
    Last Post: 09-22-2010, 01:47 AM
  3. Constract of Multiple Fields
    By KLynch0803 in forum Programming
    Replies: 6
    Last Post: 02-01-2010, 07:27 AM
  4. Replies: 1
    Last Post: 12-10-2009, 08:41 PM
  5. Multiple Fields In One Combo Box.
    By caljohn527 in forum Forms
    Replies: 1
    Last Post: 02-20-2009, 03:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums