This command has worked for well over a year: select AVG(Walk_Time) into vTotTime from Walk_Data where Route_ID NOT IN (14, 31)
It stopped working a few days ago, on the 13th. If I add "and Walk_Date < 13/02/2003" it's fine as it is if I use "and Walk_Date > 09/10/2001". I assume that the data is okay because, one way or the other, all of it can be used - and I can't see anything wrong. I have reloaded the database as well. The number of rows being selected is 437 with the ">" or 438 with the "<" than clauses. This, however, does work: compute vTotTime AS AVG(Walk_Time) from Walk_Data where Route_ID NOT IN (14, 31) It is, therefore, not a problem as there is a work-around but does anybody have any idea why the select does not work? Is the any limit on the number of rows selected for a calculation? Thanks in advance for any help, Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------
