I'm trying to setup a bar code reader to read ID cards in my after-hours database. The problem is that the ID numbers that I have in my database are 8 digits long and the bar code on their cards is 14 digits (the id number is in the middle of this 14 digits number). The numbers at the beginnings and at the end are not always the same. EX. If ID number is 12345678, bar code is XXXX12345678XX.
How do I do a search with only the middle part of the information given by the bar code reader?
if the PLACEMENT is always the same, you can use the Middle() function
Middle(myfield; 5; 8) // start with character/digit 5 and give me 8 characters exactly