In Access there is an autonumber feature that will pull up the next sequence
d
number for use in a database.  What I am trying to do is get Access to pullu
p
a sequenced number that is Alphanumeric.  I am creating invoices and need th
e
system to pull up a new alphanumeric number to crate an individual invoice
with no duplication of number.  Is this possible in Access or does it only d
o
AutoNumber with just numbers?

Would appreciate any help possible.

Thank you.

[ Post a follow-up to this message ]

You might have better luck in the Excel newsgroups.

Richard Ault
Application Center Product Team

This posting is provided "AS IS" with no warranties, and confers no rights. Use of any 
included script samples are subject to the terms specified at http://www.microsoft
.com/info/cpyright.htm

-----Original Message-----
From: ExcelNoviceInIL@discussions.microsoft.com
Posted At: Wednesday, November 02, 2005 14:36
Posted To: microsoft.public.applicationcenter.usage
Conversation: AutoNumber Feature in MS Access
Subject: AutoNumber Feature in MS Access



In Access there is an autonumber feature that will pull up the next sequence
d number for use in a database.  What I am trying to do is get Access to pul
lup a sequenced number that is Alphanumeric.  I am creating invoices and nee
d the system to pull up a n
ew alphanumeric number to crate an individual invoice with no duplication of
 number.  Is this possible in Access or does it only do AutoNumber with just
 numbers?

Would appreciate any help possible.

Thank you.

[ Post a follow-up to this message ]