Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Location
    Liverpool, UK
    Posts
    15

    Unanswered: CR7 : Memo/Blob field - getting 1st 3 chars?

    I'm trying to use the 'Insert Formula' to look at a memo field and obtain the first three characters.

    Of course, I'm now getting the famous 'Blob field or memo field can not be used in formula' message!

    I've tried using substring, in string and left - all with the same result/problem.

    I've tried creating a variable to assign the memo field to but I hit the same problem.

    Can anyone help me out with a way of doing it, please?
    Last edited by jstyles; 11-30-06 at 10:26.
    If you're too busy to go fishing . . . . . then you're too busy ! ! !

  2. #2
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1
    Try do the trimming in the sql statement.

  3. #3
    Join Date
    Sep 2006
    Location
    Liverpool, UK
    Posts
    15
    Thanks, plsh. I'll try that.
    If you're too busy to go fishing . . . . . then you're too busy ! ! !

Posting Permissions

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