Join expression not supported

[leili31az]

Hi
i'm writing a query in microsoft access , but i get this errormessage :
"Join expression not supported " .
this is the query :
SELECT count(answers.answer) as cnt from answers inner join forms on
answers.fid=forms.fid and forms.cgcode=820 and forms.termcode=25 and
answers.answer=1

can anyone help me on this problem ?

 

[Roger Carlson]

Warning, these are untested, but I'd try:

SELECT count(answers.answer) as cnt
from answers, forms
where answers.fid=forms.fid
and forms.cgcode=820
and forms.termcode=25
and answers.answer=1

or

SELECT count(answers.answer) as cnt
from answers inner join forms
on answers.fid=forms.fid
where forms.cgcode=820
and forms.termcode=25
and answers.answer=1

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Roger Carlson]

Oh, another thought.

"Forms" is a reserved word in Access. You should name the table something
else. Even if it isn't a problem here, it will be a problem eventually.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L