Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47

    Question Unanswered: getting last date of an entry

    I have a query that i need to get the last date, a certain entry was made..
    The table is called :Last_Entry
    ie:
    Code:
    ID	DATE_	        ENTRY
    
    20	08/05/2004	red
    20	01/01/2004	blue
    20	11/05/2004	green
    How can i get it so that the last entry returns the green entry.. so that i have:
    Code:
    20	11/05/2004	green
    Help much appriciated on this one.. Dave

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    You have to hit that little summation icon in design mode then simple choose max on the total line for date.

Posting Permissions

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