Robson- In this, and your last question, the problem is that you are using functions from Microsoft Access. You'll keep running into this until you learn about the equivalent functions in PostgreSQL.
The PostgreSQL functions are explained here: http://www.postgresql.org/idocs/index.php?functions.html You may also want to learn how to create your own functions in case there is no equivalent: http://www.postgresql.org/idocs/index.php?sql-createfunction.html -Nick -------------------------------------------------------------------------- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robson Martins Sent: Thursday, June 13, 2002 2:30 PM To: [EMAIL PROTECTED] Subject: [ADMIN] Err sum number with Date ? What err ? Order By (Sum(Qtde)/(1+current_date-Max(Data))) Desc Regards, Robson ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster