Incremental Invoice number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create an incremental number for my InvoiceNumber field in
the tblSaOr table which will be CI-05-number (CI-year-number)

I've googled and searched on here and come up with various solutions
involving Nz and DMax. The problem is I really don't understand the syntax or
how these work so I keep coming up with errors. I am trying things in the
control source of the InvoiceNumber field on my form, which I hope is the
right place.

Any help would be greatly appreciated.
 
Perhaps some actual downloadable samples will help. Here are three:

"AutonumberProblem.mdb" found at:
http://www.rogersaccesslibrary.com/TableOfContents3.asp

"NextNumber.mdb" found at:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Johnson,Bob

"Incremental Number" found at:
http://propertychampion.com/Developer_Tools/Addins/Addins.html

As an aside, however, let me ask this: Are incremental numbers really
necessary? Think about it before you answer. Traditionally, incremental
numbers were used in paper-based systems to make sure 1) no invoices were
lost or stolen or 2) aid in filing. Are these functions *really* necessary
in a computer based system? Why store the Year in the Invoice number? You
already have an invoice date stored (hopefully). You can use that to sort.
Why have an incremental number at all, as long as you have a unique number
to search on, the computer will find it. Random numbers would work as well.

Just some things to think about.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top