Autonumber sorting

  • Thread starter Thread starter Nate Adams
  • Start date Start date
N

Nate Adams

I am developing a system for inventory and already have a
table of products. I am trying to sort the products and
autonumber them alphabetically, but for some reason when
I input an new autonumber row it seems to number them
randomly. How can I determine the order in which
autonumber numbers an already existing table?

Thanks so much,

N Adams
 
Nate

First, Access Autonumbers are designed to serve as unique row identifiers
and are generated by Access (an "auto" number). As such, they can either be
set to random or sequential (check the properties of the field). However,
they are NOT generally fit for human consumption, and YOU don't get to enter
them.

If you want a numbering scheme YOU control, you'll have to write your own.
Fairly simple to do, using the DMax() function.

Good luck

Jeff Boyce
<Access MVP>
 
You do not "number products alphabetically" in an Access database. You
sort< them alphabetically using the ORDER BY clause of an SQL statement, or
Click to expand...
the OrderBy & OrderByOn properties of a form or report.

HTH,
TC
 
Back
Top