ACCESS FEED: RE: [MS_AccessPros] How to combine several memo fields into one memo field?

Kamis, 31 Oktober 2013

RE: [MS_AccessPros] How to combine several memo fields into one memo field?

Tim,

I assume the notes/memo records are one (company) to many (notes). I would use a subreport of the notes table in the detail section of the company main report.

If you really don't want to try the subreport, you can find a generic concatenate function at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html

Duane Hookom MVP
MS Access
________________________________
> From: timdbui@gmail.com
>
> Duane,
>
> I am creating a database to keep all of our members' comments. Say,
> "John" follows the company IBM and he keeps his notes on IBM separated
> by dates. In the course of the year, he might put in 5 or 10 notes on
> various dates. I also created a form so that any member can enter the
> ticker IBM and click print to retrieve a report that would contain all
> data kept on IBM as well as all of the notes that John had entered. If
> I can create a memo field that combines all of John's notes and put it
> in the report so others can read John's notes. I think if I cannot
> create a combined memo field, I have to create a number of memo fields
> for each of John's notes, right?
>
>
> Another problem is other members might put in their notes on IBM on
> various dates as well. A memo field that combines everyone's note would
> be very helpful so that everyone can see each other's notes on IBM.
>
>
>
> Thanks, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
> Why is it necessary to combine the memo field values into a single
> field? Reports can easily render one record under another like a
> continuous form/datasheet.
>
> Are the notes typically as brief as your examples? Is the date part of
> the memo field or a separate field?
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Hi, Would any of you please help me on this topic? I keep notes of
>> companies over time and I would like to add these notes into one memo
>> field in a report.
>>
>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
>> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
>> these notes into one memo field in a report so that the final field
>> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
>> your help! Tim