Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    memo fields in access queries (Access 2000)

    I have a union query in which one field has a memo data type. In the output of the union query, the content of the memo field is truncated to 255 characters. Is there a way to have the union query output the entire contents of the memo field?

  2. #2
    dave_hill
    Guest

    Re: memo fields in access queries (Access 2000)

    Is the Memo field in the first part of the union?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: memo fields in access queries (Access 2000)

    The memo field, called [Description] is in the SELECT, the UNION SELECT, and the last UNION SELECT. The file is attached. The end result pulls records FROM three different queries based on the publication type. (ie. Category1, Category2, BestSeller)
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: memo fields in access queries (Access 2000)

    Did you ever resolve this problem? I'm experiencing the same thing.

  5. #5
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: memo fields in access queries (Access 2000)

    I am afraid that this got pushed to a back burner without resolution. My teammates decided to remove the field from the publications catalog and use a smaller [Document Summary] field of data type text instead. A cheap workaround, I'll admit, but it worked.

    aap2

Posting Permissions

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