Search results

the example is access table with field name idcard and the format is number the data written in it 12digits (000888999111), now I'll create 12 fields in access forms like field1 and field2 ...... field12 ... check the attached

no.. they are same as id or invoice number

hey gays.... thanks for the active assist... the data from ms access table in one field name ID_NO with 12 digits, what I want to do to split these numbers into 12 fields in the access form or report like to assign the first field with the first digit and the second field with the second digit...

i had tried to find the right code for this, but no use,,, any help