field limit

From: accessnewbie (accessnewbie_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 12:23:06 -0800

I have a union query based off two tables. The sql statements are posted
below. The problem I am having is that the "Description" column is cutting
off after 255 characters. My Description field is selected to Memo in the
table. Is there something else I need to do?

SELECT [Customer], [Date Received], [Type], [Region], [Requestor],
[Description], [Date Completed] FROM [Barbara WIP]
WHERE [Type]="CPA"
UNION
SELECT [Customer], [Date Received], [Type], [Region], [Requestor],
[Description], [Date Completed] FROM [Barbara WIP]
WHERE [Type]="Procurement Agreement"

Relevant Pages

  • Re: Error Message - "Query is too complex"
    ... I am using the sql statements you listed. ... > It sounds like you might be hitting a limit for the length of SQL statement. ... When I try to run the query an error message "Query is too ... >> Is there a limit to what I can combine using union query? ...
    (microsoft.public.access.queries)
  • Re: PLEASE. update access from module
    ... Try cutting and pasting one of the sql statements shown into he query ...
    (microsoft.public.access.forms)
  • Re: Too many records
    ... Consider looking into a UNION query. ... This takes the results of query1 and ... query2 and displays them all. ... You'll have to copy the SQL statements of ...
    (microsoft.public.access.queries)