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

splitting text into characters ... HELP ME SPLIT

P: n/a
But I am trying to split material from a text box to be entered into
two different tables.

Let's I enter the word "Makebelieve" in a text box. But I want to only
enter the first three words 'MAK' in table A and the rest of of the
words 'ebelieve' in another table.

Later I also want to call them out from the separate tables and rejoin
them (I have clue about the later with queries and all. But help me
split!!!!!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See LEFT, RIGHT, MID, INSTR in the help.
Left$(strText,3)="MAK"

Then when you get the query working, turn it into an append query or
whatever you need...

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.