Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Unique Values over 255 characters (Access 2003)

    I'm trying to run a select query with the Unique Values set to yes, but I'm getting an error ("The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.). I do include a memo field that has more than 255 characters that when removed, the query runs correctly. Is this a limitation in Access?

    Thanks,
    Drew

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Unique Values over 255 characters (Access 2003)

    Yes, this is a limitation of Access. You cannot include a Memo, OLE or Hyperlink field in a query with Unique Values set to Yes. Neither can you group on such fields in a Totals query.

Posting Permissions

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