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

Custom Split Help

P: 46
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.
Feb 6 '12 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,276
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.
Feb 7 '12 #2

P: 46
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?
Feb 7 '12 #3

Expert Mod 15k+
P: 31,276
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 ;-)
Feb 7 '12 #4

P: 46
Ok so I'll try again!
Feb 7 '12 #5

Expert Mod 15k+
P: 31,276
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.
Feb 7 '12 #6

This discussion thread is closed

Replies have been disabled for this discussion.