Results 1 to 4 of 4
  1. #1
    msouriya is offline Novice
    Windows 10 Access 2007
    Join Date
    Aug 2020
    Posts
    11

    Filtering out Null Value

    I created a query based on two a query and a table that filters out Services with no dates. It has been working for years, I'm not sure why this year it's acting up. Please help me. Below is my design.
    Click image for larger version. 

Name:	QryFilterNull20-21.jpg 
Views:	15 
Size:	128.0 KB 
ID:	43585
    Attached Thumbnails Attached Thumbnails QueryFilterNull.jpg  

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    In the first one you need to change the join to Left Outter join (arrow pointing towards the table).
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    msouriya is offline Novice
    Windows 10 Access 2007
    Join Date
    Aug 2020
    Posts
    11
    Thank you for assistance, I figured it out!

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You're welcome!

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 2
    Last Post: 05-09-2020, 12:17 AM
  2. Replies: 2
    Last Post: 10-07-2019, 10:46 AM
  3. Replies: 4
    Last Post: 04-09-2019, 02:05 PM
  4. Replies: 4
    Last Post: 03-11-2017, 09:48 PM
  5. Replies: 1
    Last Post: 02-23-2012, 02:27 PM

Tags for this Thread

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