Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    Query to show blank entries


    When the add record button on my form is pressed, sometimes it is pressed without any data on the form, which will create a blank entry. Is there a way to query to display the blank records that have been entered? I am sure there is a way to do if(fieldName)=Null, but I am not sure how to do it.

  2. #2
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    Nevermind, I had my SQL statement wrong, and that's why it wasn't working for me! I designed the query, and up under the fields I wanted to be displayed if they were blank, I put Is Null, and then ran the query and they all populated. Spelling is pivotal!

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

Similar Threads

  1. Query to group and count field entries
    By newtoAccess in forum Queries
    Replies: 4
    Last Post: 11-29-2010, 09:19 AM
  2. Blank spaces at start of entries
    By rcmglover in forum Access
    Replies: 2
    Last Post: 03-26-2010, 10:42 PM
  3. Replies: 5
    Last Post: 01-28-2010, 09:10 AM
  4. Replies: 0
    Last Post: 04-03-2009, 01:15 PM
  5. Replies: 1
    Last Post: 09-05-2008, 12:07 PM

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