Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding empty fields (Access 200)

    Hello fellow loungers,

    I have a huge data cleanup project I need your expertise with....

    I need to find fields that are not being used for each group of codes. For example,
    Code 60- y2K bonus , I need to know if we entered any data for that code. If we didn't we will delete the code from the library.

    Any guidance would be helpful.

    Thanks a million!! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

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

    Re: Finding empty fields (Access 200)

    Create a query based on the table.
    Add all fields you want to check to the query grid.
    Type " Is Not Null" (without the quotes) after each field name.
    Change the query to a Totals query.
    Change the Totals option for each field from Group By to Sum.
    Change to datasheet view.
    If something has been entered into a field, the result will be negative (-5 means that something has been entered in 5 records), if nothing has been entered, the result will be 0.

  3. #3
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding empty fields (Access 200)

    Thank you for the reply...I do have a question.

    When I try to run the query it gives me a message as follows:
    "The sum or average aggregate operation cannot take a char type as an argument."

    Also- should I be adding the IS NOT NULL in the criteria section for each of the fileds I selected?

    Thank you in advance for your help. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

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

    Re: Finding empty fields (Access 200)

    Type "Is Not Null" (without the quotes) after the name of each field in the query, not in the criteria row. If the field name contains spaces or unusual characters, enclose it in square brackets. For example, if you have a field named "60- y2K bonus", use [60- y2K bonus] Is Not Null.

Posting Permissions

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