Alter Column

[Bryan Hughes]

Hello,

I have a Client DB that assigns id# for Case Managers. They use this id# to
create and file the physical file. To help Case Managers when referencing
the physical file and case file in db, I would like to add a Date part in
the id#.

What I have in mind is using 203 as the first part of ID# to signify year
2003, then autoincrement by 1. So the id# would look like 2031 or 203.1
then 2032 or 203.2, 2033 or 203.3, etc. The 203 would not change until the
year changed and autoincrement would be set back to 1.

Is this possible? If so, how can I do this? Can you set Autoincrement
fields using decimal points?

Please Help

-Bryan

 

[Rebecca Riordan]

Bryan,

An autonumber wouldn't do this. What you'll need to do is create a couple
of different fields -- a year ("203") and an increment (.1), and set them
from a form when the record is created. There's some example code on
www.mvps.org/msaccess

HTH
--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...