Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Location
    Michigan
    Posts
    2

    Is this a Query or Sorting problem?

    Ok, new to this relm. First off I'm using Access 2002 working in a tooling company, writing a tool tracking DB. What I have is :

    [Liner ID #] [Inspected Date] [Dia 1] [Dia 2] [Dia 3].... so on

    The [Dia 1] are measurements of the liners. The liner are constantly changing with the break-down of the tool. We have multiple liners ranging from Liner A-1-1 thru B-15-5. I have all the liner group in there own tables by table Liner A and Liner B.

    Question:

    Is there a way to do a query to only show only the lastest or most currert by [inspected date], for every liners with all the measurements?

    If I can just grab [liner id #] and most recent [Date inspected] info in a query, I can bring rest data with it.


    Any help with my quest for knowledge

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Try something like:

    SELECT [Liner ID #], Max([Inspected Date]), [Dia1], [Dia2], etc.....
    FROM YourTable
    GROUP BY [Liner ID #], [Dia1], [Dia2], etc.....

  3. #3
    Join Date
    Jul 2006
    Location
    Michigan
    Posts
    2
    Code:
    SELECT [Liner ID #], Max([Date Inspected]) AS [MaxOfDate Inspected]
    FROM [Liner A]
    GROUP BY [Liner ID #];

    I had a break-thru last night..... This works out great

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

Similar Threads

  1. Sorting data in a report
    By rjsiler in forum Reports
    Replies: 1
    Last Post: 08-04-2008, 01:40 AM
  2. Update Query problem
    By sollem1 in forum Queries
    Replies: 0
    Last Post: 11-08-2007, 10:16 AM
  3. Sorting By Date!
    By Pirate in forum Access
    Replies: 0
    Last Post: 07-19-2007, 02:42 PM
  4. Sorting in a subform
    By hraup in forum Forms
    Replies: 2
    Last Post: 08-29-2006, 12:35 PM
  5. Sorting in a form
    By PaulDouglas in forum Forms
    Replies: 3
    Last Post: 07-27-2006, 08:28 AM

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