+ Reply to Thread
Results 1 to 3 of 3

access database. Finding the latest status of a record between two tables.

  1. #1
    Registered User
    Join Date
    11-09-2017
    Location
    NEW YORK, NEW YORK
    MS-Off Ver
    2010
    Posts
    43

    access database. Finding the latest status of a record between two tables.

    I have a query that checks the order number of two tables. I am trying to determine the status what is the last status by date.


    Example
    Table 1
    Order number 12345
    Order start date 10/3/19 10:00 am
    Order status: in progress
    Order number 12345
    Order start date 10/4/19 11:00 am
    Order status: updated
    Order number 2222
    Order start date 10/4/19
    Orders status: open

    Table 2
    Order number 12345
    Order start date 10/3/19 10:15am
    Order status: pending
    Order number 12345
    Order start date 10/5/19 11:00 am
    Order status: completed
    Order number 2222
    Order start date 10/5/19
    Orders status: investigate


    I want the results to provide me the earliest start date and latest status of the order. So it should compare table 1 which is when I create my orders to Table 2 which is when I began to process them.

    I would want it to provide the latest date and latest status.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: access database. Finding the latest status of a record between two tables.

    Please upload a database with a representative sample of your data. Be sure to dummy up sensitive data. Once you have the file ready (Your scaled down version). Run a compact and repair. Then you will need to zip the file as this site does not upload .mdb or accdb files. With a sample db, we can then manipulate the data in a query and not have to guess as to the data formats.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-09-2017
    Location
    NEW YORK, NEW YORK
    MS-Off Ver
    2010
    Posts
    43

    Smile Re: access database. Finding the latest status of a record between two tables.

    Hi Alan,
    Thank you for your assistance. But was able to get the answer for a co-worker.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding latest data record with different dates
    By Rubyod in forum Excel General
    Replies: 4
    Last Post: 04-10-2015, 12:44 AM
  2. Lookup latest status from database
    By adam2308 in forum Excel General
    Replies: 2
    Last Post: 12-08-2013, 09:23 PM
  3. Read MS Access Database to Get Last Record
    By Vladamir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2012, 04:42 PM
  4. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  5. Search for a record in an Access database?
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2011, 04:40 AM
  6. Finding the newest / latest date in each record
    By Statsman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2009, 07:40 PM
  7. combining multiple access tables in Access Database
    By Reema in forum Access Tables & Databases
    Replies: 3
    Last Post: 03-25-2009, 12:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1