Autonumber sorting

[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

 

[Jeff Boyce]

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>

 

[TC]

You do not "number products alphabetically" in an Access database. You

sort< them alphabetically using the ORDER BY clause of an SQL statement, or

the OrderBy & OrderByOn properties of a form or report.

HTH,
TC