Hi.
I've got a table "table1" with field Serial_no and model (among others).
the serial number of the product has a following format:
A9BC1234567 - Month,Year,Factory,Model and 6 digits.
when i input the serial number on the form (field "Serial_no") i want access to recognize the string, take 4th character and based on that placed a apropriet value, like Model1 or Model2, in the field "Model".
Can somebody help me with that one.
Thanks.
I've got a table "table1" with field Serial_no and model (among others).
the serial number of the product has a following format:
A9BC1234567 - Month,Year,Factory,Model and 6 digits.
when i input the serial number on the form (field "Serial_no") i want access to recognize the string, take 4th character and based on that placed a apropriet value, like Model1 or Model2, in the field "Model".
Can somebody help me with that one.
Thanks.