Results 1 to 3 of 3
  1. #1
    Racingrl is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Jun 2012
    Posts
    2

    Counting fields in a single record


    I have developed a database where we have multiple fields that are simply IN or OUT. We want to count the number of "Outs" in a record. We also have sections where there are just "Yes/No" boxes and want to count the number of "No's" or the value (0). I see that Count is just for counting records where a certain field is selected with a certain value. Has anyone been able to form a query that will do this in a single record?
    Thanks!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Please tell us more about your database and tables.
    we have multiple fields that are simply IN or OUT.
    these are values for fields, right?
    You may have a table structure issue.

  3. #3
    Racingrl is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Jun 2012
    Posts
    2
    I basically set up a simple a separate table for look up that has as the default "IN." Each field of the form is a different question and is a combo box, but looks up values in the same table.

    ID Field1
    1 IN
    2 OUT
    3 N/A
    4 N/O

    I want to count the number of times in the record that "OUT" occurs, for instance. Basically, we are scoring each record on whether or not they were in compliance.
    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. counting fields
    By mcchung52 in forum Queries
    Replies: 2
    Last Post: 03-08-2012, 04:00 PM
  2. Counting Yes No Fields
    By pwilson in forum Queries
    Replies: 3
    Last Post: 11-29-2011, 10:29 AM
  3. Searching and calculating fields from a single record
    By karmacable in forum Programming
    Replies: 9
    Last Post: 09-25-2011, 01:11 PM
  4. Counting only 'checked' Yes/No fields on a
    By pwdpwd in forum Programming
    Replies: 9
    Last Post: 04-14-2011, 09:28 AM
  5. Replies: 7
    Last Post: 11-13-2010, 08:08 AM

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