Results 1 to 3 of 3

Comparing data Day over Day

  1. #1
    Teatimedgg is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    1

    Comparing data Day over Day

    Hi Everyone, I know there must be away to do this and any help would be greatly appreciated. So here we go..
    I have a table that has tasks imported daily with a input date. I am looking for a way to do the following:
    I need to see the previous days tasks that are not in the current days and any tasks that are still there but the some or all fields have changed. This will give me what has been completed and what tasks are still there but have been changed and still need to be worked.
    Example: Fields








    Not sure if this would be able to work but any ideas would help! thank you in advance! Tea

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,257
    no information to provide a more detailed answer other than use a subquery to find the previous record. Plenty of examples online - just google/bing 'SQL subqueries' - here is an example https://www.essentialsql.com/get-rea...ect-statement/

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,603
    Q1, qsTodayEvents : all events today
    Q2, qsPrevDayEvents: all the events of the previous day
    Q3: bring in Q1 & Q2, join them on the task,
    make the join an OUTER join (dbl-click the join line), set to: show all items in Q2, some in Q1
    bring down Task from both queries.
    run query
    the recs with Q1.Task is null shows what got finished yesterday (I assume)

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

Similar Threads

  1. VBA For Comparing Data From Multiple Tables
    By Botfly in forum Programming
    Replies: 4
    Last Post: 02-08-2019, 01:13 PM
  2. Comparing data
    By chr1stoper1 in forum Queries
    Replies: 3
    Last Post: 07-27-2016, 03:52 AM
  3. Comparing form data to table data
    By lefty2cox in forum Programming
    Replies: 20
    Last Post: 02-12-2016, 10:13 AM
  4. Comparing Data From Two Tables
    By dcoley in forum Access
    Replies: 12
    Last Post: 05-01-2014, 12:09 PM
  5. Replies: 14
    Last Post: 01-07-2014, 04:20 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
  •  
Tech Forums: Microsoft Office Forums