Results 1 to 2 of 2
  1. #1
    Maroota is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    1

    MS Query Last Transaction Date Formula Required


    Hi All

    I am new to the forum and this is my first post.

    I am using MS Query to extract data from an Asset Database to an excel spread sheet.

    The data being used is a list of assets and their movement over a period of time.

    Is there a formula I could use to extract all the assets (Unique Ref is "Serial_Number"), but only the latest dated ("entry_data") line of data for that asset.

    Many thanks



    Diane

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Use "Group By" and "Max" on the "Entry_Data" should get you there.

    SELECT TABLENAME.SERIAL_NUMBER, MAX(TABLENAME.ENTRY_DATA)
    FROM TABLENAME
    GROUP BY SERIAL_NUMBER;

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

Similar Threads

  1. Simple Query to Retrieve a Date for a Formula
    By dgutsche in forum Queries
    Replies: 4
    Last Post: 09-08-2014, 11:55 AM
  2. Replies: 2
    Last Post: 07-17-2014, 01:46 AM
  3. Replies: 17
    Last Post: 11-06-2013, 05:38 PM
  4. Replies: 8
    Last Post: 06-05-2013, 03:39 PM
  5. Replies: 7
    Last Post: 11-14-2011, 05:59 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
  •  
Other Forums: Microsoft Office Forums