HyperBPP
asked on
Access how to subquery longtext data.
Using Access 2013. I have a query with a subquery that pulls from a longtext column. When I execute I get the error "Invalid memo, OLE, or Hyperlink Object in subquery 'YC_Comments'." HOw do I subquery a longtext? Query sample:
SELECT (SELECT Comments FROM Programc where c.ID_FK = a.id_fk and c.State_ID_FK = a.State_id_fk ) AS Expr1, *
FROM fulfilment AS a LEFT JOIN Ref AS b ON a.id_fk = b.id;
SELECT (SELECT Comments FROM Programc where c.ID_FK = a.id_fk and c.State_ID_FK = a.State_id_fk ) AS Expr1, *
FROM fulfilment AS a LEFT JOIN Ref AS b ON a.id_fk = b.id;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A typo error:
"FROM Programc where c.ID_FK = a.id_fk"
===>FROM Program c where c.ID_FK = a.id_fk
"FROM Programc where c.ID_FK = a.id_fk"
===>FROM Program c where c.ID_FK = a.id_fk
ASKER
Ah. That was "duh" moment for me.
I have a pretty deep dent in my own forehead.
SELECT Comments FROM Programc where c.ID_FK = a.id_fk and c.State_ID_FK = a.State_id_fk
Either is Programc a query by itself, or a and c is missing.
Make the subquery run by itself. It will probably hold some invalid entries in field Comments.
/gustav