You must Sign In to post a response.
  • Category: .NET

    Auto number in Access

    I need to have an auto number in an access query, this is not the auto number already existing in the table. I need a separate auto number field in the query which begins with 1 and is in increasing order.
    Any help will be much appreciated

    Thanks for advance
  • #241245
    select row_number() over (order by fieldName) as SlNo, * from tableName

    This query gives you a column like serial number. This will work in SQL Server alone.

    You just try it in MS Access.

  • #241262
    I tried in MS Access. but not worked.

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.