Re: field limit

From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 02/04/05


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"



Relevant Pages

  • Re: creteria macros
    ... Having written the Union Query, if you have control over the Tables, I suggest basing a Make-Table Query on the Union Query and creating a Table containing all the records from the separate Tables. ... Class1_ID STATUSFIELD DATEFIELD ... So let's enter the new creteria once for Date and Status field and have it forwarded to each of the queries for CLASS1 through to CLASS8. ...
    (microsoft.public.access.queries)
  • Re: Union Query
    ... I definitely understand you comment about normalization. ... What happens with the "union" table is that it get's linked to ... here's the essentials of how to build a Union query. ... Each SELECT subquery may have other clauses (eg. ...
    (microsoft.public.access.queries)
  • Re: Union Query
    ... here's the essentials of how to build a Union query. ... FROM Table2 ... Each SELECT subquery may have other clauses (eg. ...
    (microsoft.public.access.queries)
  • Re: Sum Report
    ... I would specify the actual field names in the first UNION query you ... I would not include joining to tblName until after the UNION query has been ... > FROM tblName INNER JOIN tblTRAdmin ON tblName.NameID = ... >>>> tblName: NameID, Names, TRDate ...
    (microsoft.public.access.reports)
  • Re: Union Query
    ... if the first SELECT subquery has fields ... if you attempt to union a datetime field ... I definitely understand you comment about normalization. ... here's the essentials of how to build a Union query. ...
    (microsoft.public.access.queries)