• Ignore empty fields in count (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Ignore empty fields in count (2000)

    Author
    Topic
    WSSoxRule3530
    AskWoody Lounger
    July 29, 2003 at 6:40 pm #391204

    When you set the Totals field of a Query to “Count”, any way you can get it to ignore fields that are empty and only count how many have something in them? Thanks.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      July 29, 2003 at 6:54 pm #697760

      If you want to count the number of records that have a value in a specific field, enter “Not Null” (without the quotes) in the Criteria line under that field.

      Reply | Quote
    Viewing 0 reply threads
    Reply To: Reply #697760 in Ignore empty fields in count (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.