sqlplus to Access Syntax Issue -

i unable find answer has helped me resolve issue. part of organization @ university requires our students meet attendance criteria per our required meetings each semester. track whether our students meeting criteria or not want create report show me list of students have missed required meetings , how many meetings have missed between dates x , y.

the following query wrote works fine when run through sqlplus

select s.first_name, s.last_name, s.email, count (a.student_mnumb) attendance_count  student_attendance inner join student s on s.student_m=a.student_mnumb inner join event e on e.event_name=a.event_name1 e.event_date>'01-aug-13' , e.event_date<'01-dec-13' , e.student_req='y' , a.attend='n' group s.first_name, s.last_name, s.email having count (a.student_mnumb) > 0; 

however, when enter query access receive following error: "syntax error (missing operator) in query expression 's.student_m=a.student_mnumb inner join event e on e.event_name=a.event_name'.

my database hosted through oracle 11gxe , running odbc create reports on ms access 2007. have tried same query updated table titles per odbc account name (student becomes bap_student) , issue persists.

any appreciated. thanks!

since query works in oracle already, create access "pass through" query asks oracle directly give results query. way wouldn't need convert query oracle access sql.

or simpler, create oracle view based on query. access, create odbc link view.

if need convert access sql, db engine requires parentheses queries include more 1 join.

from     (student_attendance     inner join student s     on s.student_m=a.student_mnumb)     inner join event e     on e.event_name=a.event_name1 

a change should past first syntax error. however, encourage use access' query designer set joins. knows rules parentheses keep db engine happy, , can handle detail you.

you may encounter other issues. example, access uses # characters delimit date/time values. so, if access sees event_date field date/time type, try in where clause ...

    e.event_date > #2013-08-01# , e.event_date < #2013-12-01#