Automatic Numbering

[macneilj]

How do I get Access to assign a unique number automatically? I have three
tables that need to have Access assign different number in each table. The
first table will have a number like D809-00000 and needs to assign the next
higher number D809-00001 and so on. The next table will have a number like
D809-10000 and needs to assign the next higher number D809-10001 and so on
the third table will have a number like D809-30000 and needs to assign the
next higher number D809-30001 and so on. Any Help would be greatly
appreciated.

 

[Steve Schapel]

Macneilj,

Is the D809- the same for all the records in your database? If so, you
don't need to store this. By far, the easiest way to handle this is to
use an AutoNumber data type for this field, and set its Format property
to...
"D809-"00000