UNION vs. UNION ALL query

[Baldrick]

I am writing reports from a SQL Server DB with Access.

Access will let me do a UNION ALL query, but a UNION query (which would eliminate dupes)does not work. I get an error message about Can't do union on Memo or OLE Object field...

Why would it work on one and not the other?

 

[Baldrick]

Thanks for the feedback Pat. I'll try your suggestion.

 

[Baldrick]

Pat,

Thanks for your advice. I used the Left() function in the existing data field in my query "CLT_IMPCT: Left([CLT_IMPCT_TXT],255)" and it worked beautifully.