Adam, Thanks for the assist.
The query works fine without the ( ) arount the conditions. Now on to the next part. George ----- Original Message ----- From: "Adam Royle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 10:03 PM Subject: [PHP-DB] Re: PHP/Access problem 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php