Custom Split Help

[moishy101]

I've inherited a mdb with hundreds of thousands of records the problem is that there is no structure to the tables.
The issue I'm dealing with now is the following:
The table includes 5 columns, ID, Month1, Amount1, Month2, Amount2.
The problem is that each one of the Month an Amount fields have multiple records separated by the + sign.

The question is how can I split each record to a separate field?

Your assistance is much appreciated.

[NeoPa]

I think you'll need some VBA code to separate out the mess. As starter there is a function Split() you should read up on in Context-Sensitive Help that will almost certainly be helpful.

I'm afraid we are not able (allowed) simply to do it for you. You will need to start the work yourself then you may be in a position to post a valid question with the required details.

Good luck.

[moishy101]

The trouble I'm having with Split() is that not all ID's have the same number of records in each column (in fact very rarely they do), how do I return an array that has empty elments?

[NeoPa]

I suspect this is not what you're after, but the actual answer to the question you asked is simply "By name".

Clearly the reason that is no help to you is that the question you asked was very unclear and didn't express properly what you want to know. If you ask the question again properly, with relevant details, I'm sure we can help. Remember, if you put 5 seconds' thought into the question, it's not reasonable to expect it to express your point very clearly, and very few will want to waste their time helping on a question that even the questionner doesn't feel is worth more than a few seconds of their time ;-)

[moishy101]

Ok so I'll try again!

[NeoPa]

And good the new thread is (Help with custom use of Split()). I'll lock this one to further posting to ensure answers are all found in the same place.