How to Increment Number Format

D

DazedConfused

I know this must have been answered before but I am new to Access 2000.

I have a incrementing AutoNumber field set up for an Invoice Numbering
System.
How or what formatting code would/could I use to accomplish this?
I would like to format the number like this and increment it by 1 each time
I create an Invoice.

Field Name: InvoiceID

example: WSI-0001, WSI-0002, etc

Thanks in Advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment Number Format 2
Incrementing/Formatting this Number Question 1
Automatic increment of Invoice number 3
Record Number Format 4
How to code an Invouce Number 2
Increment Alphabetical Character 1
keeping track of "Escaped" Autonumber records 7
DMax on existing record to increment serialized # fails 1

Top