SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND
Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by
Author,Title


should be


SELECT * FROM Documents WHERE (CourseRef='4712' AND
Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by
Author,Title


your table name should not hae single quotes around it...

adam

Reply via email to