Truncate Memo field in Union Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mail Merge Help - 20 Jun 2007 01:14 GMT

Good day

I have created a Union Query between two tables. Everything works fine
except the Memo field that truncated to 255 character.

I would appreciate it could anyone please help me how to fix this truncate
issue in Union Query. I want display every details in the field.

Many thanks and have a nice day

Reply to this Message

Rick Brandt - 20 Jun 2007 01:22 GMT

> Good day
>
[quoted text clipped - 6 lines]
>
> Many thanks and have a nice day

UNION eliminates duplicates and that is what truncates a memo field. A UNION
ALL (which does not eliminate duplicates) would not truncate a memo.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Mail Merge Help - 20 Jun 2007 04:05 GMT

Hi Rick

Thanks for the advise but how do I create a Union All.

Below is my union command.

SELECT ProjectID, RecID, RecommendationNo, AuditFinding, Recommendation,
FROM Recommendations;

UNION SELECT ProjectID, RecID, RecommendationNo, AuditFinding,
Recommendation,
FROM Archived_Recommendations;

> > Good day
> >
[quoted text clipped - 9 lines]
> UNION eliminates duplicates and that is what truncates a memo field. A UNION
> ALL (which does not eliminate duplicates) would not truncate a memo.

Reply to this Message

Rick Brandt - 20 Jun 2007 04:17 GMT

> Hi Rick
>
[quoted text clipped - 8 lines]
> Recommendation,
> FROM Archived_Recommendations;

See change above.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Mail Merge Help - 20 Jun 2007 04:19 GMT

Thanks Rick

I just found out how to create a Union All

> Hi Rick
>
[quoted text clipped - 22 lines]
> > UNION eliminates duplicates and that is what truncates a memo field. A UNION
> > ALL (which does not eliminate duplicates) would not truncate a memo.

Reply to this Message

John W. Vinson - 20 Jun 2007 04:19 GMT

>Thanks for the advise but how do I create a Union All.

SELECT ProjectID, RecID, RecommendationNo, AuditFinding, Recommendation,
FROM Recommendations;

UNION ALL SELECT ProjectID, RecID, RecommendationNo, AuditFinding,
Recommendation,
FROM Archived_Recommendations;

That is... just replace the keyword UNION with UNION ALL.

John W. Vinson [MVP]

Reply to this Message

Mail Merge Help - 20 Jun 2007 04:27 GMT

Dear John and Rick

Thanks for getting back to me in such a short time. I have found out that
all I need to do is all the word ALL between the UNION SELECT.

Thanks once again. This advise is very usefull.

> >Thanks for the advise but how do I create a Union All.
>
[quoted text clipped - 8 lines]
>
> John W. Vinson [MVP]

Reply to this Message