Data continues to next record 1

[ITGUY99]

Hope you can help me out with this, I am really having trouble figuring this out. Basically, I am pulling data from an AS/400 into access. I have a table that is for comments. The comments go something like this:
Field1 Field2 Field3
1 1 This is a test of the emerg
1 2 ency broadcasy system th
1 3 is only a test!

As I hope you can see, field3 keeps over-wrapping to the next record. What I would like to do is have it something like this:
Field1 Field3
1 This is a test of the emergency broadcast system…..

Any ideas if and how I can do this in access. It seems like it should be an easy thing to do, I just haven’t been able to figure it out. Thanks in advance.

 

[dhookom]

Try this Concatenating function faq701-4233. There is a sample of how it works at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

You could create a make table or append query with the results of the query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ITGUY99]

Thank you for the super fast reply, I will try it a let you know. 15 hours is too much for one day. THANKS