Results 1 to 2 of 2
  1. 09-23-2017, 05:42 AM #1
    Erictsang
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154

    how to queries field that is not null?

    Dear



    How can i short out in queries for those which is not null?
    Reply With Quote Reply With Quote
  2. 09-23-2017, 07:20 AM #2
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,418
    use is not null - e.g.

    SELECT *
    FROM myTable
    WHERE Field1 is not null
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. If field is not null, check if other field is null - Please help me write this out
    By wtucker in forum Programming
    Replies: 3
    Last Post: 06-30-2017, 10:56 AM
  2. In an access 2013 report I want to null one field if the other is not null
    By Bernard in forum Access
    Replies: 7
    Last Post: 11-07-2016, 09:24 AM
  3. Working with queries and null values
    By guidout in forum Queries
    Replies: 6
    Last Post: 03-26-2015, 05:53 PM
  4. Almost identical queries, one says invalid use of null
    By jrg24 in forum Queries
    Replies: 5
    Last Post: 05-02-2014, 10:15 AM
  5. Return a value of zero for null queries
    By adacpt in forum Access
    Replies: 2
    Last Post: 01-22-2012, 07:41 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums