Gaps in AutoNumber

  • Thread starter Thread starter Dave_T
  • Start date Start date
D

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
 
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>
 
Back
Top