Can automating Employee ID be done?

[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.

 

[M.L. Sco Scofield]

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

 

[MacDermott]

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