Gaps in AutoNumber

[Dave_T]

I am printing a report that has an autonumber as a
Transaction No in a Stock Issue Database. I need to
develop a report that shows all consecutive transactions
as a group (i.e. 1-4, 8-10 etc), but cannot seem to find
the correct way to do this (if it is possible at all!)

Can anyone out there help?

David

 

[Jeff Boyce]

Dave

The Access Autonumber is designed to be used to uniquely identify table
rows, and allow for a primary key/foreign key relationship. It is almost
certain to not be sequential (if someone starts a new record and <Esc> out,
that Autonumber is not reused), and is generally unfit for human
consumption.

If you need a numbering system that you can control, you'll have to create
one yourself. Check one of the Access websites (e.g., www.mvps.org/access/)
or on Google.com (the ms access database group) under the topic "custom
autonumber".

Good luck

Jeff Boyce
<Access MVP>