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

Try the Mid function:

sEmpCode = Mid$(sBarCode, 2, Len(sBardcode) - 3)

HTH,

Jim DeMarco
Director of Product Development
HealthSource/Hudson Health Plan


-----Original Message-----
From: Canales, Hector [mailto:canalesh at bsci.com]
Sent: Monday, March 31, 2003 9:14 AM
To: 'accessd at databaseadvisors.com'
Subject: [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


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************