How to Generate Serial Number Column in MS Access Query
- George Apostolov
- 05 Sep 2025
Guide
Go to the 'Create' tab.
Select 'Query Design'.
Switch to 'SQL View'.
Enter the following SQL code and adjust field and table names as needed.
Click 'Run' to run the query.
Create your first interactive demo in minutes
No credit card required • Start building today