I have barcode reader that I use as data entry and we have two different barcodes one has 8 digits and the other has 9 digits.
I set up form where I scan items and it puts in the table as 12345678 or if it is 9 digits as 123456789. whit these numbers I like to change as follows.
8 digits = 123-45678
9 digits = 1234-56789
I'm not sure if this possible in access and if it is I like to know how to proceed. Please help
I set up form where I scan items and it puts in the table as 12345678 or if it is 9 digits as 123456789. whit these numbers I like to change as follows.
8 digits = 123-45678
9 digits = 1234-56789
I'm not sure if this possible in access and if it is I like to know how to proceed. Please help