This is a Oracle query... its working in Oracle but didnt work in access...
select v.code_number,v.vehicle_number,v.company_code,r.fc_valid_to,
i.next_due_date
from (vehicledetails v left outer join rtodetails r
on v.code_number=r.code_number AND v.code_number='SMR5'
left...