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