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?
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?