Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Question Unanswered: Report that displays the most recent record.

    I am slightly higher than a novice, but I've not worked in Access in about 3 years. I've managed to set up a small project tracking database for our department. I'm having difficulty building a query that only displays the most recent record entries.
    Context: Users enter records ("Project Updates"). They may be working on more than one project, so they make entries for each of them. Currently, they can enter updates as often as they'd like. Some perform a "once-weekly" update, per project. Others prefer to enter updates as they occur through out the week. Each entry has a date field ("Status Date") and I'm trying to key my query on this field. I want to build a report that displays the most recent record (or Update) per project, per employee. I can't figure a way to do that or even if that's possible or the right approach.

    Any assistance would be greatly appreciated.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sort the data into descending date order and then set the queries "Top" property to 1.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2009
    Posts
    2

    Question Almost there...

    I really appreciate the assistance. I still have a problem. There are 12 projects against which employees are making entries. With your recommended settings, the query returns 5 of them. Interestingly enough, the 5 records each share an 8/5/09 entry date. The latest updates for these 12 projects range from 7/31 to 8/5/09. Also, the last (or most recent) entry for any of the records is 8/5/09. Any thoughts on what could be the issue?

    Thanks again for your help.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't think I have enough information to help on that one. But it may be me, I'm quite unwell and seeing stars :Þ

    Do you have a separate table for these "entries"?

    If you could reveal the table structure of your database and what exactly you want to see and what you currently have then it may be easier to see where the problem is.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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