Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634

    Unanswered: Convert memo to text

    I have a field that I need to use in a graph. The data type is memo and I can not change the data type at the table level (yet). Is there a way to output this field as text in a select query?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try an explicit conversion to say string cstr(<mycolumn>) as <mytextcolumn>, do a string operation eg left$(<mycolumn>,<nocharacters) as <mytextcolumn>

  3. #3
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Thanks, cstr is exactly what I needed. I knew there had to be a function, but I couldn't find it in help (of course, I rarely find anything in help).

  4. #4
    Join Date
    Mar 2010
    Posts
    1

    Convert memo to text

    1.create an empty table with the same existing field name.
    2.change all table field to 'text'
    3.create a query from the existing table with all field included.
    4.change the select query to append query.
    5.append to the new table.

    there u r..u get ur new table with any data field type u want.

Posting Permissions

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