7 ways to do sequential numbering

[Uncle Gizmo]

Very interesting and informative post here:-

https://accessexperts.com/blog/2015/07/28/ways-to-do-sequential-numbering-in-access/