Truncate Memo field in Union Query

[Mail Merge Help]

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

 

[Rick Brandt]

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

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

 

[Mail Merge Help]

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;

 

[Rick Brandt]

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 ALL SELECT ProjectID, RecID, RecommendationNo, AuditFinding,
Recommendation,
FROM Archived_Recommendations;

See change above.

 

[Mail Merge Help]

Thanks Rick

I just found out how to create a Union All

 

[John W. Vinson]

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]

 

[Mail Merge Help]

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.