Truncated memo field problem

[itchyII]

Hi Everyone,
I searched the boards and found out that I'm not the only one with this problem but I don't know what to do about it!! My query is simple enough, no calculations, etc. So what can I do to avoid the truncation of my memo fields?

SELECT * FROM s_master_1

UNION SELECT * FROM s_master_2

UNION SELECT * FROM s_master_3

UNION SELECT * FROM s_master_4

UNION SELECT * FROM s_master_5

UNION SELECT * FROM s_master_6

UNION SELECT * FROM s_master_7

UNION SELECT * FROM s_master_8

UNION SELECT * FROM s_master_9

UNION SELECT * FROM s_master_10;

Thanks

ItchyII

 

[dhookom]

Try use "UNION ALL" rather than "UNION".

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[itchyII]

Thanks Duane! Worked beautifully!

ItchyII