How do I set automatic Purchase order # on access

R

Remi

I will like to set up an automatic purchase order number on access. Example
number Ranges from 0005-0001 to 9999-9999 to automaticly change and increase
by 1 after every transaction. Pls Help Thanks
 
J

jahoobob

Why are you bigining at 0005? Is it the year? If it is, do you want t
reset the last four digits at the beginning of each year?
 

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

Finding the proper style field and the numbered paragraph value within the style 0
Automatic number fill-in on Labels 3
Incrementing PART NUMBER on form 4
Finding the right style field in VBA 0
Reference Document 8
Section and Page numbering 0
Word isn't capitalizing the first word of each sentence 2
QUESTION on Purchasing Database - RECEIVING PARTS 4

Top