[RESOLVED] MS Access SQL Question ...

[TheBionicOrange]

I am using MS Access 2000.

Why does this query give me a syntax error ?
All field names are correct, and both joins should be "inner".

select a.QUESTION_GROUP,a.QUESTION_ID,a.WEIGHTING,a.CONTROL_MEASURE_OWNER,a.CONTROL_MEASURE_APPROVED,a.COMPLETION_TIMESCALE,b.CONTROL_MEASURE,c.QUESTION
from AUDIT_LOCATION_QUESTION_RESULTS a 
inner join AUDIT_CONTROL_MEASURES b on (a.CHAIN=b.CHAIN and a.QUESTION_GROUP=b.QUESTION_GROUP and a.QUESTION_ID=b.QUESTION_ID) 
inner join AUDIT_GROUP_QUESTIONS c on (a.CHAIN=c.CHAIN and a.QUESTION_GROUP=c.QUESTION_GROUP and a.QUESTION_ID=c.QUESTION_ID)
where a.CHAIN = '01' 
and a.BRANCH_NUMBER = '0001' 
and a.AUDIT_DATE = '20060502' 
order by a.QUESTION_GROUP,a.QUESTION_ID