Hi Im getting this error

Microsoft Cursor Engine error '80004005' 



Data provider or other service returned an E_FAIL status



with this statement

sql = "SELECT unit.unit_id, unit.unit_title,unit.module_id,  

assessment.assessment_id, assessment.assessment_title "&_

	  "FROM [unit] LEFT JOIN assessment ON (assessment.unit_id = 

unit.unit_id) "&_

      " GROUP BY unit.unit_id, unit.unit_title, unit.module_id, 

assessment.assessment_id, assessment.assessment_title  HAVING ( 

((unit.module_id) = "&varModuleID&")  )"



its something to do with the assessment.assessment_id being an autonumber 

as, if I exclude this field from the statement or change the key to a 

Number datatype  it works fine.

Incidentally the error is given on the line...



myRS.movenext



any ideas please??