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

Canales, Hector canalesh at bsci.com
Mon Mar 31 08:13:42 CST 2003


  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


More information about the AccessD mailing list