how can I format for autonumbering in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lenthel Drachler - 30 Dec 2004 16:09 GMT

I am trying to get my access to count numbers for me, and I can not get it ti
format what I need I am using a accession number of PM-05-0001 to start can
anyone tell me how I need to set this up to automatically put in my numbers
for me.

Reply to this Message

Amy Vargo - 30 Dec 2004 20:49 GMT

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

You can use a custom value and use the code in the article below as an
example:

209830 ACC2000: How to Increment the Numeric Portion of a String
http://support.microsoft.com/?id=209830

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Amy Vargo
Microsoft Access Engineer

This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

Reply to this Message