field limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an union query created that pulls data from two tables. However, when
the query runs the "Description" column cuts data after 255 characters. I
have it set to Memo on both tables. Is there something more I need to do to
my statements below to show all the data?

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"
 
Back
Top