union query, cuts off data of merged memo field

P

Philip Leduc

Hi ,

I am working on a database that was build by someone else where I need to
merge two tables (from different forms) with a simlar (data) structure in to
one
query for a report.
Using an union query, I do notice that I lose data of the memo field , it
seems like to cut of at a certain point?
How do I get the entire memo field in my merged query?
 
A

Allen Browne

Access truncates the memo field at 255 characters if your query performs any
aggregation on the field. Since a UNION query de-duplicates records, it will
truncate the fields at 255 characters.

A UNION ALL does not de-duplicate.
Try replacing UNION with UNION ALL.
 

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

Page numbering with Merged Document and IF statements 1
Query field size quandry 2
Totals query and Memo field 3
UNION query truncating MEMO column ! 10
data cut of in Union query, memo field 0
Union query changes Memo to Text (256 char limit) 1
Memo fields in a query 10
union query memo field 0

Top