Hi George, Just at a quick glance it might be to do with the Date(); Remove that clause and see what happens. I could be wrong. Rgds, Michael "George Pitcher" <george.pitcher@ingenta.com> escribió en el mensaje AMEPJAJDOFCDLPGFDOIFMEODCHAA.george.pitcher@ingenta.com">news:AMEPJAJDOFCDLPGFDOIFMEODCHAA.george.pitcher@ingenta.com... > 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
