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

paul.hartland at fsmail.net paul.hartland at fsmail.net
Mon Mar 31 08:24:13 CST 2003


Try some code similar to the following

myfield = mid(barcode,2,len(trim(barcode))-3)

Paul


From: "Canales, Hector" <canalesh at bsci.com>
Date: Mon 31/Mar/2003 14:13 GMT
To: "'accessd at databaseadvisors.com'" <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


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.




More information about the AccessD mailing list