By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

How to perform an opposite of CONCATENATE on a form

P: n/a
Hi,

I have a text field in format 000123456789 and I have to split this
text field into 12 separate text fields. So this would have to look
something like this:

Field1 has a value 0,
Field2 has a value 0,
Field3 has a value 0,
Field4 has a value 1,
Field5 has a value 2,
Field6 has a value 3,
Field7 has a value 4,
Field8 has a value 5,
Field9 has a value 6,
Field10 has a value 7,
Field11 has a value 8,
Field12 has a value 9.

I have to admit that I don't have a slightest clue on how to achieve
this and would really appreciate help. The reason I have to separate
this field is because I have to multiply each number inside the field
with a different ponder in order to calculate a control number for my
reports.

Thanks for your help,
Matej
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 18 Oct 2004 05:33:48 -0700, ma************@email.si (matejp) wrote:

Check out the Mid$ function in the Help file.
E.g. Mid$(MyTextField, 1,1) = 0

-Tom.

Hi,

I have a text field in format 000123456789 and I have to split this
text field into 12 separate text fields. So this would have to look
something like this:

Field1 has a value 0,
Field2 has a value 0,
Field3 has a value 0,
Field4 has a value 1,
Field5 has a value 2,
Field6 has a value 3,
Field7 has a value 4,
Field8 has a value 5,
Field9 has a value 6,
Field10 has a value 7,
Field11 has a value 8,
Field12 has a value 9.

I have to admit that I don't have a slightest clue on how to achieve
this and would really appreciate help. The reason I have to separate
this field is because I have to multiply each number inside the field
with a different ponder in order to calculate a control number for my
reports.

Thanks for your help,
Matej


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.