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