The date format in my query works fine with Access. I solved the problem by splitting the query into two separate queries and it now works fine. Cheers George > -----Original Message----- > From: Disko_kex [mailto:disko_kex@swedish-mushroom.com] > Sent: 29 September 2003 1:25 pm > To: 'George Pitcher' > Subject: RE: SQL query problem > > > Try this: Pack.End > "'.date("Y-m-d").'" > > be sure that you have the same dateformat > > > > > Hi, > > I'm having a problem with the following query (ODBC on M$ Access): > > select Pack.*, Transacts.*, Extracts.* from Pack, Transacts, Extracts > where > ( > Pack.End > date() and Pack.Term='Lent' and Transacts.Week=1 and > Transacts.Pack_ID=Pack.Pack_ID and Extracts.ID=Transacts.Extract_ID) > ORDER BY Pack.Term DESC, Transacts.Week ASC, Pack.Course_ref ASC > > I get a 'no records' return. > > Any suggestions for re-jigging the query. > > Cheers > > George in Oxford > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
