Select Query Character Limit

[jrshaw03]

I have many select commands all linked together by unions. For example:

SELECT "a _GENERAL ITEMS" as Category, [General Items] as Item from [Mk 36 01Jan Source] UNION SELECT "c _OPN FUNDING", [Blank Space] FROM [Mk 36 01Jan Source] UNION.....

My problem is that my fields (ie General Items) are faced with a character limit. I think it is around 250. The fields are all memos and in my source query the entire text box is captured. It is only in the Union query where I see the character limit. Does anyone know how to circumvent this problem? I guess the answer is to make Item into some sort of memo field, but I do not know how.

Thanks,
Jimmy

 

[dRahme]

Hello, two suggestions. Shorten your naming conventions as much as possible - SELECT "a _GENERAL ITEMS" as Category to
aGenItms as Cat - and still make it meaningful.

The other, if that is not possible - consider a make-table and append the union items to it.

Hope that helps.

 

[jrshaw03]

dRahme,

I want my information to be displayed in a newsletter format, with:

Heading
Entry 1
Entry 2
Heading
Entry 1
Entry 2
Entry 3 ....
The problem is that these entries extend beyond the 255 character limit. I was thinking of splitting the fields into part 1, 2, 3... So I could get 255 + 255 + 255... characters. Would the make table allow this or should I try something else?

Thanks,
Jimmy

 

[accessewbie]

I have two tables linked by a union query. Here is my statement:

SELECT *
FROM [BARBARA WIP]
WHERE [IS THIS A CONTRACT?]=YES
UNION SELECT *
FROM [SARA WIP]
WHERE [IS THIS A CONTRACT?]=YES;


My problem is that one of my fields (Description) is faced with a 255 character limit. The fields in the tables are all set as memo. It is only in the union query where I see this character limit. Does anyone know how to get around this problem?
Thanks!

 

[PHV]

Have you tried UNION ALL ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[accessewbie]

That worked. Thanks!

 

[dhookom]

PHV,
How did you miss responding to the first request from jrshaw03?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jrshaw03]

No worries,

I should have closed out this topic last week. I ended up finding the UNION ALL answer through some better searching.

Jimmy