Incrementing/Formatting this Number Question

[JustMe]

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

 

[Tim Ferguson]

example: WSI-0001, WSI-0002, etc

If the WSI is strictly unchanging, then there is no need to store it at
all. Just use a format property on the Form or Report textbox like

"WSI"0000

or put in in the query.

If the WSI does change from warehouse to warehouse (or whatever), then you
need two fields to hold the two separate bits of information, the text code
and the serial number. How you allocate the SerialNumber part is up to you,
but in most cases you may need a little bit of VBA.

Hope that helps


Tim F