At 02:25 AM 26/02/2004 +0000, you wrote:

>Good day everyone.
>
>Iam having trouble to write a sql statement that gives a average sales
>amount for a month for a customer on a invoice table which has this
>following fields(not a complete list of fields)
>
>invoice table
>1. invid
>2. customerid
>3. invdate
>4. totalamount
>
>Anybody has tried doing this?

average sales for what? per month over the year? per month for ever? per
invoice?

/hb