locked
Get access highest Index Key number RRS feed

  • Question

  • User507348793 posted

    Hi , im wondering how to get the highest number in access Key index Integer colom and when  inserting data the nuber must be plused by one

    For instance say i got a booking number 4 in the key index colom and when i insert a  booking  without out a booking number how can i add just one  and insert it into access database so then in the colom it would be 5 and so on

    Thanks


    Friday, August 20, 2010 8:51 AM

Answers

  • User-1360095595 posted

    In Access I think it's called an AutoNumber field.  When you insert a new record, it will automatically increment the value for you. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 20, 2010 9:12 AM

All replies

  • User-1360095595 posted

    In Access I think it's called an AutoNumber field.  When you insert a new record, it will automatically increment the value for you. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 20, 2010 9:12 AM
  • User507348793 posted

    Thx for reply

    Yes i know thanks but i need to do it with C# Coding

    Friday, August 20, 2010 9:20 AM
  • User-1360095595 posted

    I guess I don't understand what it is that you need to do in C# since the field is auto-incremented for you.  Can you clarify your needs?

    Friday, August 20, 2010 9:41 AM
  • User507348793 posted

    Ill Get back to you i need to test out some stuff..


    Friday, August 20, 2010 9:59 AM