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
