Separate Information on Query

[lions1855]

Hello,

I have a query with a paragraph that needs to be split in two. In other words, normally in word program, I would hit the "Enter" Key. But, in access query, one is no so sure how this process is done.

COuld you provide an example on how to split the two paragrah.

For example, if the query shows:

BBBBBBBBBBBBBBBBBANNNNNNNNNNNNNNNNNNNNN

The query should be able to do this.

BBBBBBBBBBBBBBBBB

ANNNNNNNNNNNNNNNNNNNNN

Thanks

 

[DCrake]

This indicates that there is no carriage retrun in the body of the text. If you are editing this paragraph in a form via a text box then set the keyboard behaivour to new line in field. That way if you press return it will insert a carriage return in the body of the text.

 

[lions1855]

Thanks for your suggestion. However, I was looking for a query update, select, or append that will do this for me. There are 2000 plus records. It would be a collosal job doing one by one.