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