Join expression not supported

  • Thread starter Thread starter leili31az
  • Start date Start date
L

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 ?
 
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
Click to expand...

Try:

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

Jamie.

--
 
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
 
Back
Top