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;
LVL 6
HyperBPPAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
I'm not sure why this is a subquery at all.  Why would you not just join to Programc using a left join?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
Soemthing is missing here:

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
Hamed NasrRetired IT ProfessionalCommented:
A typo error:
"FROM Programc where c.ID_FK = a.id_fk"
===>FROM Program c where c.ID_FK = a.id_fk
HyperBPPAuthor Commented:
Ah.  That was "duh" moment for me.
PatHartmanCommented:
I have a pretty deep dent in my own forehead.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.