Tried: SELECT * FROM calendar WHERE Year < #2000-12-31# AND Year > #2000-01-01# ORDER BY Start ASC supplied by "mqqla". I used his format against an Access 2000 database and it worked perfectly. dm ""Keith Spiller"" <[EMAIL PROTECTED]> wrote in message news:03f301c03e46$2515c370$6bdaead8@enigma... Using the select command, how would you retrieve listings only between certain dates? "SELECT * FROM calendar WHERE Year < '2000-12-31' AND > '2002-01-01' ORDER BY Start ASC" ??? (This does not work)... Is this even possible? Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
