Tabel renewal

[OveB]

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

 

[Jeff Boyce]

If you have more text than fits in a text field, consider changing it to a
memo field.

Jeff Boyce
<Access MVP>

 

[OveB]

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
..

 

[Jeff Boyce]

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>

 

[OveB]

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

 

[Jeff Boyce]

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>