Gaps in a Sequence Number

Hi,

I'm in need of some expert help in sorting a numerical/alphanumerical
employee ID field (5&6 characters in length).

Also seperating the alphanumerical IDs and finding the gaps in the
sequence
numbers (These numbers will always begin with a "C").  Reason for this is
to
assign an unused alphanumeric number to a employee.  Therefore only one
unused alphanumeric number needs to be viewed at a time.  The original
database designer used the...   DoCmd.GoToRecord , , acLast to locate the
last record.  It has become useless since I am at C99999.  It is a 2003
database.  Can this be done with Visual Basics?  I will be glad to forward
a
sample of the database.

Thanks
Jaka


Example:

Table: Employee
Field: EmployeeID

C1345
C0001
45573
100023
C1356
C1347
C1349

Sorted data;
C0001
C1345
C1347
C1349
C1356

Individual gap result;
C0002
C0003
C0004 etc....