need help with how this is done

  • Thread starter Thread starter Rob McDonald
  • Start date Start date
R

Rob McDonald

I want to build a database which will help my parents with invoicing at the
small company they own. Presently theya re at invoice number 15133 or so
doing everything the old manual way. I want to continue on where they have
left off with the database. I want to use invoice number as the primary key
and have it start there. Is there a way that this can be done? Any help
would be much appreciated
 
Rob McDonald said:
I want to build a database which will help my parents with invoicing at the
small company they own. Presently theya re at invoice number 15133 or so
doing everything the old manual way. I want to continue on where they have
left off with the database. I want to use invoice number as the primary key
and have it start there. Is there a way that this can be done? Any help
would be much appreciated
Click to expand...

You can use an autonumber, or write your own code. If you use an
autonumber, append a record with an invoice number of 1 less that the number
you want to start at to your table. After you add your first "real" record,
you can delete the dummy record and Access will increment properly from then
on.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Tahnk you very much for the help on this item. I appreciate it ! Have a
great New Year
 
Back
Top