Tech Support Guy banner
Status
Not open for further replies.
1 - 8 of 8 Posts

·
Registered
Joined
·
4 Posts
Discussion Starter · #1 ·
This forum seems great, so I'm hoping someone can help me. I need to create a field that has the year and then an auto-number. Like 2011-135. However, there's a catch. There are already records in my DB that I don't want changed. (Last year, people manually entered 2010-##.) So, how can I: a) create this field, and b) make it start with only new records entered?

thanks!
 

·
Registered
Joined
·
4 Posts
Discussion Starter · #5 ·
Okay, I'm back. I was out a couple of days.

The table is "Investigations" and the field that has the autonumber is called "AutoID". That is a hidden field. I've also got another field I was allowing users to enter a number manually in the formate YYYY-###. That is called "Case#".
 
1 - 8 of 8 Posts
Status
Not open for further replies.
Top