Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    65

    Unanswered: 'last' is not a recognised function name

    Hi all,

    ive tried to run a query in a view and am getting this error message:

    'last' is not a recognised function name

    i was sure that last was used in sql, how can i get the same result if it wont accept 'last'?

    greg

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    use MAX

    LAST is a microsoft access function
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2006
    Posts
    65
    oh yeah!! forgot the syntax changed-

    cheers

    greg

Posting Permissions

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