 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / April 2005Tabel renewal
I have a table with two columns, one with a number and one with text. Some numbers are repeated owing to the text line being too long. I want the text to appear on one single line for each number in the first column. Is there a way to fix this?/Ove If you have more text than fits in a text field, consider changing it to a memo field. Jeff Boyce <Access MVP> >I have a table with two columns, one with a number and one with text. Some >numbers are repeated owing to the text line being too long. I want the text >to appear on one single line for each number in the first column. Is there >a way to fix this?/Ove Let me explain by a faked example: Line 1 #111 MAPS Line 2 #111 GEOGRAPHIC MAPS ARE BUILT UP FROM Line 3 #111 MEASUREMENTS ON THE FIELD Thus the lines have been cut long before the 255 limit and are continued on the next line, that has been given the same number. The first line with a new # seems to be a heading Acutually I would also prefer not to stick to capitals but the problem is that there are no periods in the texts /Ove . > If you have more text than fits in a text field, consider changing it to a > memo field. [quoted text clipped - 6 lines] >>text to appear on one single line for each number in the first column. Is >>there a way to fix this?/Ove One approach would be to create a function that reads the table, concatenates the text portion as long as the # hasn't changed, and writes the # and the concatenated string to a new table, before "resetting" and starting on the next. Jeff Boyce <Access MVP> > Let me explain by a faked example: > Line 1 #111 MAPS [quoted text clipped - 17 lines] >>>the text to appear on one single line for each number in the first >>>column. Is there a way to fix this?/Ove Jeff, Sorry, I previously answered to you directly by mistake, Hope it will now come to you in the correct way. - I would very much appreciate a more detailed help as I am a novice. I guess the content has been written in another program and then been transformed in a wrong way. Regards/Ove > One approach would be to create a function that reads the table, > concatenates the text portion as long as the # hasn't changed, and writes [quoted text clipped - 25 lines] >>>>the text to appear on one single line for each number in the first >>>>column. Is there a way to fix this?/Ove Ove Most of the folks who respond in these newsgroups are, as I am, volunteering their time. If you don't have much experience creating a function, using code in a module, or programming, you may find the effort of doing this in Access to be more than you can afford... and it would take more time than I can afford to volunteer. Perhaps another newsgroup reader has more time available to help on this. Or another idea might be if you can manually modify the original material in Word or Excel or some other program before importing into Access ... Good luck Jeff Boyce <Access MVP> > Jeff, > Sorry, I previously answered to you directly by mistake, Hope it will now [quoted text clipped - 3 lines] > transformed in a wrong way. > Regards/Ove |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.