Results 1 to 3 of 3

Thread: Latest date

  1. #1
    Join Date
    Dec 2012
    Posts
    2

    Unanswered: Latest date

    Hi

    New to this forum

    I used to work a lot on MS Access but it's been a long time since i've done any, and my memory is pathetic.

    I used to have a line in a report query criteria that gave me the latest date that work had been carried out on a particular fleet vehicle but i can't remember for the life of me what i put in there.

    can anyone help??

    Cheers

    Drew

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try the max() function

    or use the top() function with an appropriate sort order
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2012
    Posts
    2
    Sry messed about with the max function but i'm like a headless chicken. would you please give me the dummys guide.

    I have reg number, inspection date, vehicle type. just need a line that will just return me the last date that each vehicle was inspected.

    Thanks

    Drew

Posting Permissions

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