- Joined
- Dec 7, 2012
- Messages
- 10
- Reaction score
- 0
Hi,
I'm an absolubt beginner with databases ad need some help removing a special characters.
I have a field that contains numbers only in some cells and both numbers and letters in others. In order to be able to inport to my DB I had to add a ' at the beginning and end of each record so that both excell & access would pick up the dta as text. I now need to remove the ' characters but cannot figure out how it's done.
I know I need to use an update query from reading other threads here but nothing I have read has given me an answer I can understand or impliment.
please help.
P.S.
I have no knowledge on using SQL so any help needs to be in very simple access term
Thanks in advance.
I'm an absolubt beginner with databases ad need some help removing a special characters.
I have a field that contains numbers only in some cells and both numbers and letters in others. In order to be able to inport to my DB I had to add a ' at the beginning and end of each record so that both excell & access would pick up the dta as text. I now need to remove the ' characters but cannot figure out how it's done.
I know I need to use an update query from reading other threads here but nothing I have read has given me an answer I can understand or impliment.
please help.
P.S.
I have no knowledge on using SQL so any help needs to be in very simple access term

Thanks in advance.