Numbering

[Ben]

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?

 

[Duane Hookom]

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

 

[Martin]

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.