Would like to create an invoice

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

Guest

Hi all
I would like to create an invoice in Access 2000/2002. This invoice should start at 00001 and continue as long as the river flows

Would it better to create the invoice in another program, maybe Excel? But how do I format it to start at 00001 and get it to continue at a new number continuously when I print out a new invoice?
 
When you create a table (perhaps even an invoice table) with an Autonumber
primary key, it always starts at 1, and continues sequentially until the mud
sets. You can't change its format to something like 00001, but you can do
that on all your forms and reports using the Format function:

Format(lngMyNum, "00000")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

akrc said:
Hi all,
I would like to create an invoice in Access 2000/2002. This invoice should
Click to expand...
start at 00001 and continue as long as the river flows.
Would it better to create the invoice in another program, maybe Excel? But
Click to expand...
how do I format it to start at 00001 and get it to continue at a new number
continuously when I print out a new invoice?
 
Back
Top