By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Need autonumbering help (novice level)

P: n/a
Have set up a inventory of IT equipment in a small school, and I need to
give each item a unique serial number, ie: DHRS 01,
DHRS 02, etc the text is needed as we intend to security mark, once database
finish
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 12 Feb 2004 20:34:09 +0000 (UTC), Robin Lumley wrote:
Have set up a inventory of IT equipment in a small school, and I need to
give each item a unique serial number, ie: DHRS 01,
DHRS 02, etc the text is needed as we intend to security mark, once database
finish


More info is needed. What do you need to do next? Is the table constructed?
Do you just need to get the serial numbers in? How do you determine what
item gets what serial number?

--
Mike Storr
veraccess.com
Nov 12 '05 #2

P: n/a
"Robin Lumley" <r.******@btinternet.com> wrote in message news:<c0**********@hercules.btinternet.com>...
Have set up a inventory of IT equipment in a small school, and I need to
give each item a unique serial number, ie: DHRS 01,
DHRS 02, etc the text is needed as we intend to security mark, once database
finish


You should read this article:
http://www.mvps.org/access/strings/str0007.htm
"Increment Numeric portion of a string"
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.