Can automating Employee ID be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If we want employee id to be thier 2 initials and a sequential 4 digit number
starting at 100. What is the best/ most practical way to do this in SQL?
I'd like to know how to do it in VB but I don't know any of that. I already
have thier initials, I just need to add a counter to it and get it in the
right field.
 
No way to do this in Access (Jet) SQL that I'm aware of.

There is code that you can use and modify to do what you want in the article
at http://support.microsoft.com/default.aspx?scid=kb;en-us;210194.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
You can use an autonumber to generate "sequential" numbers - they're
guaranteed to be unique, but there may be gaps in the sequence.
I'd suggest that you use this number as your primary key, only prepending
the initials when necessary to display them on forms and reports.

HTH
 
Back
Top