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 for your reply as well, John! I am grateful for all of your helps. Tim

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

Tim-

It would help to know the layout of your tables. If you have multiple memo
fields in one record, that won't work. You need one record per note.
Perhaps:

CUSIP
MemberID
CommentDate
Comment

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Thursday, October 31, 2013 3:38 PM
To: Access Professionals Yahoo Group
Subject: 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@...
>
> 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