Duane,
I forgot to answer your other questions:
- Each note is normally less than 5 lines (about 1 paragraph).
- The date for each of the note is on a separate field so that I can sort.
Thanks,
Tim
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
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:
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@...
>
> 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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar