I Have An access Table with a field consisting of imported numbers i.e. 1,followed by A vaired number of 0,s 3 followed by o,s Etc .I would like to use a query to update the field to the number value eg the field values may be 1 0 0 0 0 0 3 0 0 0
Which would become 1 1 1 1 1 1 3 3 3 3
