Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Yes/No (Access 03 SP1)

    (Edited by HansV to insert <!t>[pre]<!/t> and <!t>[/pre]<!/t> tags to preserve spacing.)

    I am after a specific result or look when counting all yes/nos in a yes/no field. I need the results to display the row headings YES and NO even if the count for either, or both, is zero. For example, to count the number of active members, I want the results to look like this:
    <pre>Active Member Count
    Yes 19
    No 6
    </pre>

    Or if c count is zero, then:
    <pre>Active Member Count
    Yes 25
    No 0
    </pre>

    I can get the counting to work, but the row headings display 0 and -1, which isn't too user friendly!

    Thanks

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

    Re: Count Yes/No (Access 03 SP1)

    Have you tried to set the Format property of the Active column to Yes/No? If it is not in the list, you can enter Yes/No manually.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Yes/No (Access 03 SP1)

    Yes, I've tried doing that but no success.

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

    Re: Count Yes/No (Access 03 SP1)

    Please provide more information about the query. You haven't told us how you got it to list non-occurring values with a count of 0.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Yes/No (Access 03 SP1)

    It's nothing special. One month there might be all Yes', another might be all No's, but usually it's both. It just depends on what data is there at the time.

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

    Re: Count Yes/No (Access 03 SP1)

    In a standard Totals query you can set the format of a Yes/No field the way you want. You state that it doesn't work for you, so I thought that you had done something special.

    Can you attach a stripped down copy of the database?

Posting Permissions

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