Acc97 query won't work in AccXP

K

Ken

I am using the following query in Acc97, but it does not
work in AccXP (all I get is an empty table for a result):

SELECT DISTINCTROW tblQuestion.QuesNum,
tblQuestion.QuesText, tblQuestion.AnsShort,
tblClass.Class, tblClass.ExamType, tblQuesKA.KA
FROM tblQuestion INNER JOIN (tblQuesKA INNER JOIN tblClass
ON tblQuesKA.QuesNum = tblClass.QuesNum) ON
tblQuestion.QuesNum = tblClass.QuesNum
WHERE (((tblQuestion.QuesText) Like [KEYWORD (Use this
format: *KEYWORD*)]));

The data type for the field QuesText is OLE Object and
there is a word document linked to it.

In Acc97, I can search for any word contained in the word
documents linked to QuesText, but cannot figure out how to
make it work in AccXP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top