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

Kamis, 31 Oktober 2013

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

Thanks, Duane! Let me try both the SQL and the subreport.

Regards,

Tim

---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Tim,

I believe the concatenate function allows you to enter the delimiter in the function call. You can use
Concatenate("SQL STATEMENT",Chr(13) & Chr(10))

Personally, I would try a subreport.

Duane Hookom MVP
MS Access

________________________________

> To: MS_Access_Professionals@yahoogroups.com
> From: timdbui@...
> Date: Thu, 31 Oct 2013 07:50:49 -0700
> Subject: RE: RE: [MS_AccessPros] How to combine several memo fields
> into one memo field?
>
>
>
>
> Duane,
>
> Concatenate is exactly what meant to ask. Just couldn't come up with
> the right term.
>
>
> Yes, it is one company to many notes.
>
>
> I read the link that you gave and understand it.
>
>
> Do you know how can I break the concatenation by a new line, rather
> than by a comma? It would be easier to read if each of the note is
> separate by a blank line, rather than a period or a comma.
>
>
> Thanks again, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> 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@...<mailto:timdbui@...>
>>
>> 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<mailto:MS_Access_Professionals@yahoogroups.com>,
>>
> <ms_access_professionals@yahoogroups.com<mailto: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
>
>
>