Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Highest value in a table back to VB

    I've appended a trainingrecord which iv'e slightley modified back to the original table and its autoentered a ID code for this new record. I need to know this id number for the next bit of my VB code. This record will have the highest ID number but I'm not sure how to get/query this info from this table. Any help would be apprieciated.

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    SELECT Max(anyTable.ID) AS [MaximumID]
    FROM anyTable;

Posting Permissions

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