field limit

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

Guest

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"
 
You can try switching to a UNION ALL query vice a UNION query.

The union is finding only distinct rows of data and to do so it automatically
truncates the Description to 255 characters.

BUT looking at your query I don't understand why you are using a UNION query at all.

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

The above should give you the same results.

Normally you use a UNION when you need to combine records from different tables
or where you use need to combine different sets of fields from the same table.
 
Back
Top