Re: field limit
From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 02/04/05
- Next message: John Spencer (MVP): "Re: Use Query Result As Criteria For Query"
- Previous message: MGFoster: "Re: Pivot table using query"
- In reply to: accessnewbie: "field limit"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 03 Feb 2005 19:30:13 -0500
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.
accessnewbie wrote:
>
> 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"
- Next message: John Spencer (MVP): "Re: Use Query Result As Criteria For Query"
- Previous message: MGFoster: "Re: Pivot table using query"
- In reply to: accessnewbie: "field limit"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
