Numbering

I am creating a purchase order Database and am hoping to
use autonumber with the prefix "STA-04". Is this
possible, and if so, how?

If it is always STA-04 then you never need to store it.

--
Duane Hookom
MS Access MVP


"Ben" wrote in message
...
I am creating a purchase order Database and am hoping to
use autonumber with the prefix "STA-04". Is this
possible, and if so, how?

If you always want to append the "STA-" to the beginning
of the autonumber, I would use an expression in the
reporting to append the constant to the autonumber field
from the table. Something like: "STA-"&AUTOFIELD, where
AUTOFIELD is the name of your autonumber field in the
table.

Hope this helps.

-----Original Message-----
I am creating a purchase order Database and am hoping to
use autonumber with the prefix "STA-04". Is this
possible, and if so, how?
.