G
Guest
I have a database with a primary key of customer number that I have set to a
field size of 5. There are already a few reocrds in the table which is also
link to several other tables. I received a list of current customers to
import but the customer numbers all have 1 leading zero in front of the
customer number(some have several zero's which begin the customer number as
well.)
I am needing the code to remove only the first zero using an update query or
other.
any help would be greatly appreciated.
field size of 5. There are already a few reocrds in the table which is also
link to several other tables. I received a list of current customers to
import but the customer numbers all have 1 leading zero in front of the
customer number(some have several zero's which begin the customer number as
well.)
I am needing the code to remove only the first zero using an update query or
other.
any help would be greatly appreciated.