Truncate Memo field in Union Query

G

Guest

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
 
R

Rick Brandt

Mail said:
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
Click to expand...

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

Guest

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;
 
R

Rick Brandt

Mail said:
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;
Click to expand...

See change above.
 
J

John W. Vinson

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

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]
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union query truncates data 9
combining 2 queries (union) causes field to be truncated 3
Data in Memo Field is truncated 1
Make Table Query Truncating Memo Field at 255 Characters 2
SQL statment " union query" 1
Union Query and Memo Felds - truncating at 255 characters 1
Query in vb.net not returning all characters in access memo field 1
Why does Access truncate memo fields in a report? 2

Top