Results 1 to 4 of 4

Thread: Get Last Autonumber from Ms Access

  1. #1

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    707

    Get Last Autonumber from Ms Access

    Hi

    Is there some way , for to get the last Autonumber from Ms Access , without to use SELECT MAX() ?



  2. #2
    Lively Member
    Join Date
    Aug 2005
    Posts
    116

    Re: Get Last Autonumber from Ms Access

    you can use lastrecord in record set

  3. #3
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Get Last Autonumber from Ms Access

    whats wrong with max()...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  4. #4
    old fart Frans C's Avatar
    Join Date
    Oct 1999
    Location
    the Netherlands
    Posts
    2,926

    Re: Get Last Autonumber from Ms Access

    Select Top 1 MyAutonumberField From MyTable Order By MyAutonumberField DESC

    But I don't see any benefits with select max()
    Frans

Posting Permissions

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



Click Here to Expand Forum to Full Width