Hi guys,
I'm attempting to build a small simple access database, where a student swipes their ID card and it registers that they have signed in to school. Unfortunately the ID number the card gives has tags in it, for example, at the start and end of the ID number, the card has a '?' to delimit the characters. My question is, how can I put some code in to ignore the first question mark and on the last question mark, ignore the character, and then press 'enter' to be ready for the next student.
Thanks for any help