# How to Generate Serial Number Column in MS Access Query

> To generate a serial number column in a query in Microsoft Access, go to the Create tab, select Query Design, and switch to SQL View. Next, enter the SQL code while adjusting field and table names as needed, and then click Run to execute the query.

Canonical: https://livedemo.ai/tutorials/how-to-generate-serial-number-column-in-ms-access-query/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3ebcab56e05a00fe690d/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Switch to 'SQL View'.
4. Enter the following SQL code and adjust field and table names as needed.
5. Click 'Run' to run the query.