Results 1 to 7 of 7
  1. #1
    gambesq is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    4

    Unmatched records on a specific date

    I have 2 tables: tasks and tasksAssigned. Both are related by the IDTask. I need to see which ones were not assigned on a specific date. I was thinking to check the IDTask assigned on a specific date and compare with the Tasks (which are not going to change as it is the main table); however, everytime I tried to do so the results are empty



    SELECT Dailytask.TaskName, T_Desc2.WorkingDate,
    FROM Dailytask LEFT JOIN T_Desc2 ON Dailytask.[ID] = T_Desc2.[IDTaskName]
    WHERE (((T_Desc2.WorkingDate)=#1/1/2019#) AND ((Dailytask.TaskName) Is Null));

    Any thoughts?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Try a right join instead or change the direction of your join

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Are these match fields of the same data type??

    Code:
    Dailytask.[ID] = T_Desc2.[IDTaskName]

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Try writing your code as a query in the query grid.

    This should point our your mistake, then you can use this query as your record source

  5. #5
    gambesq is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    4
    Yes, the do.

    Quote Originally Posted by orange View Post
    Are these match fields of the same data type??

    Code:
    Dailytask.[ID] = T_Desc2.[IDTaskName]

  6. #6
    gambesq is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    4
    I'll do that. Although I have to research what is the difference between them

  7. #7
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Can you cut your database down so as to hide personal info.
    Get rid of Queries Forms and reports.

    Then post your database here so we can have a proper look and advise you correctly.

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

Similar Threads

  1. Replies: 6
    Last Post: 06-30-2017, 02:15 PM
  2. Get records after specific date and time
    By rooster in forum Queries
    Replies: 6
    Last Post: 09-15-2013, 11:32 PM
  3. Query and unmatched records
    By jlgray0127 in forum Forms
    Replies: 1
    Last Post: 03-19-2012, 05:56 PM
  4. Help! Unmatched Records Query
    By Hberg in forum Access
    Replies: 1
    Last Post: 03-09-2012, 03:41 PM
  5. Replies: 1
    Last Post: 12-08-2011, 01:52 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