Results 1 to 2 of 2
  1. 08-09-2010, 01:19 PM #1
    Balen
    Balen is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    13

    how can i get lastest date


    Hi i want to get the lastest date in query can you help me?
    Reply With Quote Reply With Quote
  2. 08-09-2010, 01:22 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    That's a bit nebulous, but a query would be:

    SELECT Max(FieldName) AS MaxFieldName
    FROM TableName

    You could also use a DMax() function.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Date Increment from User defined start date in a Form
    By Hobbes29 in forum Forms
    Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  2. Set date field on subform to date variable
    By laavista in forum Access
    Replies: 4
    Last Post: 06-30-2010, 06:32 PM
  3. set date field on form to date variable
    By laavista in forum Access
    Replies: 3
    Last Post: 06-28-2010, 03:03 AM
  4. wanting to subtract a date from the current date.....
    By softspoken in forum Queries
    Replies: 9
    Last Post: 03-19-2010, 10:37 AM
  5. Make sure end date is one year greater than start date
    By AimeeK in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:29 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums