Start new number on January 01

2

23510VA

We have been using Access97 based database in a clinical laboratory for
last three years. I would like to start specimen number as 04-00001 for
the year 2004 in the existing specimen table, which as number
03-XXXXX.
Your help will be highly appreciated.
 

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

How to initiate record number on new year? 1
DATE STATISTICAL 1
Creating Criteria when account number is formatted as text 2
Creating a "grid" of data 3
Find Lotttery Most Drawn Numbers 5
Week Number Format 4
Help with a Select Into query 1
Sequential Numbering on field in Access 1

Top