Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data in Memo field (Access 2K)

    Here's the deal. A memo field is used to keep track of activities generated by investigators. They will enter a short date and a brief description of what they did. Next time they will go to the end of the field, do a CR and go through the process again. The memo filed ends up with several little paragraphs. Is there a way to print a report with only the last entry in the memo field being actually printed? Any ideas appreciated. Thanks in advance!

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Data in Memo field (Access 2K)

    I am not sure how you could do what you are trying to do unless you are able to count the total carriage returns and then take the data from the last CR to the end. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    However, I would not recommend going this route using memo fields. Have you considered modifying the database and keep the data in tables. I.e., Have investigators in one table and link the investigators as a one to many relationship to an activities table. The activities table could then hold the date in one field and a description of activities in another (as well as other items). This would give you the ability to not only do what you want, but much more flexibility in reviewing activities over time.

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Data in Memo field (Access 2K)

    Trying to just print the last paragraph in a memo field would difficult. A better approach would be to have multiple records for these comments. For example, each of these Comment records would have in it a CaseNo field, a date field, and a comment field. If each day's comment is <=255 characters, it can be a text field rather than a memo.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •