G Guest Nov 24, 2004 #1 Hi, I need to add "A" TO THE begining of some numbers, How do i do this Thanks
J John Vinson Nov 24, 2004 #3 Hi, I need to add "A" TO THE begining of some numbers, How do i do this Click to expand... "A" is not a numeric digit. It cannot be added to a Number type field without causing an error. If your "numbers" are identifiers which happen to consist of numeric digits stored in a Text field, you can update the field to "A" & [fieldname] in an Update query. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
Hi, I need to add "A" TO THE begining of some numbers, How do i do this Click to expand... "A" is not a numeric digit. It cannot be added to a Number type field without causing an error. If your "numbers" are identifiers which happen to consist of numeric digits stored in a Text field, you can update the field to "A" & [fieldname] in an Update query. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
