I wound up solving it using Allen Browne's method here: http://allenbrowne.com/ser-63.html
Where a "dummy" memo type filed is added in to the query to trick it, and it worked.
I changed:
Code:
SELECT ID, pNAME, DescP1, DescP2
FROM DESC_CB_BP_QB
UNION ALL
SELECT ID, pNAME, DescP1, DescP2
FROM DESC_FusBP_QB;
to:
Code:
SELECT ID, pNAME, SellingNotes AS Desc
FROM Product WHERE (False)
UNION ALL
SELECT ID, pNAME, DescP1 & DescP2 AS Desc
FROM DESC_CB_BP_QB
UNION ALL
SELECT ID, pNAME, DescP1 & DescP2 AS Desc
FROM DESC_FusBP_QB;