[AccessD] How to subtract first digit and last two numbers from a barcode?

Take only the middle text, see the code

mid(txtString, 2,7)

with this take part from txtString

regards

Juan Menendez
Mastercafe SL

-----Mensaje original-----
De: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]En nombre de Canales,
Hector
Enviado el: lunes, 31 de marzo de 2003 16:14
Para: 'accessd at databaseadvisors.com'
Asunto: [AccessD] How to subtract first digit and last two numbers from
a barcode?


  Hi List,
I need help, I am creating a combo box where the user will scan an employee
ID and the ID number needs to mach with the employee ID on the tblEmployees.
The problem is that the barcode it has extra numbers.
Example:
%061207502 (This is what scans)
0612075 (this are the numbers that I need)
%1008937007 (This is what scans)
10089370 (this are the numbers that I need)
%100239505 (This is what scans)
1002395 (this are the numbers that I need)
%0601443503 (This is what scans)
06014435 (this are the numbers that I need)

How can I tell Access to subtract the first digit (%) and the last 2 numbers
(XX), and
Just match the reaming numbers?
It is the first time I am working with Access, it could be something simple
but I'm having a hard time.

Thank you,
Hector
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com