Adding New Record Based on Previous Value

[dennis g]

Currently we issued case numbers to officers in the field manually. The case number is made up of the last two digits of the current year, the two-character station number for the officer, and a 6 digit case number. Example: 0152003498. We also log the officers badge number when we issue it, for obvious reasons. I'd like to automate this and put it out on a network drive so the officers can get their case numbers without calling in. The case number has to increment by 1 over the last case number issued. I'd like to prompt the officer for his idcard, his station number and the criminal code (3-6 characters). Only the station number is used to generate the case number, I want to store the other two items with the record. Any bites?

 

[Matthew Snook]

I found something the other day that might address this issue. Try this link: http://www.mvps.org/access/strings/str0007.htm

Is that what you're looking for? I haven't tried this method yet...

Matt

 

[dennis g]

This may do the trick. It looks like it. Thanks for the boost.