adding text to a memo field using a text box / query? 1

[traffas]

I would like to use a memo field to list data obtained through the use of a text box. Multiple record from entries -- dumped into one 'memo field' for use in a report. I have exausted all of my resources....... Please help

Many Thanks.......

Traffas

 

[tlbroadbent]

I'm not sure that understand completely but I think you want to concatenate the data from one column in several (or all) rows of a table into a memo column in another table. If that is the case, then the following should give you an idea about how to proceed.

This query updates TableA memo column by concatenating values from the text column on TableB. Use the NZ function to eliminate NULL values.

UPDATE TableA, TableB
SET TableA.MyMemo = NZ([TableA.MyMemo],"&quot & NZ(TableB.MyText, "&quot
WHERE (<your criteria, if any>);

This query works in Access 2000. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions in the SQL Server forum. Many of the ideas apply to all forums.