how to separate 12 digits to many fields in access

[kkahaleh]

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

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

Where is the data coming from? If from a text file, this would be easy.

 

[The_Doc_Man]

The usual way we solve this is to ask for samples. Give us the inputs that you have and the outputs you would desire. If there are exceptions in the likely inputs or outputs, specify those. Since you didn't actually give us a reason WHY you wanted this or in what context, all we can do is guess. HOWEVER... if your 12 digits are date/time related (yymmddhhnnss format, for example), there might be a few ways to do this that are logically easy to understand without having to parse out text.

 

[kkahaleh]

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 of the 12digits and so on.....

 

[Gasman]

Look at Mid() function and a loop 1 to 12

 

[pbaldy]

Welcome to the site. I moved your thread to a more appropriate forum.

 

[The_Doc_Man]

If you are doing this because of report-formatting reasons, I guess it makes sense. Concur with Gasman's advice. The Mid() function will do what you want.

Mid function (Visual Basic for Applications)

Office VBA reference topic

docs.microsoft.com

 

[gemma-the-husky]

Why would each digit of a 12 digit code be relevant individually?
Are the digits really separate flags?

 

[Eugene-LS]

- "...how to separate 12 digits to many fields in access?"
There are many ways ...
How "separate"? - by what rules ?

 

[kkahaleh]

Why would each digit of a 12 digit code be relevant individually?
Are the digits really separate flags?

no.. they are same as id or invoice number

 

[kkahaleh]

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

 

[CJ_London]

rename your fields with relevant names and parse the number - see attached

 

[Eugene-LS]

Here you are !