Hello there,
remember me?
The one you help with "simple sum question" ! The data base I just created is great and I'm so prowd of it.
But ... I got stucked at the end !
I was trying to have each costumer to own a card (fidelity card, magnetic one). So I bought the card reader, I ordered the cards, etc. The problem is that when I try to swipe the card it returns the whole information on it, including track separators. The data loocks something like that ;123456789? How can I remove the unwanted characters so the database can recognize only the numeric part. I heard about Mid function but how can I make it work for me?
You're the only one I know that can help with access!
thank you again for all your help!
m
remember me?
The one you help with "simple sum question" ! The data base I just created is great and I'm so prowd of it.
But ... I got stucked at the end !
I was trying to have each costumer to own a card (fidelity card, magnetic one). So I bought the card reader, I ordered the cards, etc. The problem is that when I try to swipe the card it returns the whole information on it, including track separators. The data loocks something like that ;123456789? How can I remove the unwanted characters so the database can recognize only the numeric part. I heard about Mid function but how can I make it work for me?
You're the only one I know that can help with access!
thank you again for all your help!
m