>Hi all
>
>I need to make a SQL statement to retrive the month sales for all customers filtered by start date and end date (Ex: Start: 2005-01-01 End 2005-12-31).
>
>

So i need customer 0001 sales January, february, etc...
>                   0002 sales january, march, etc.

>
>Any smart aproach to do that.
>

You can SELECT with GROUP BY 'customer' and 'MONTH(SaleDate)' and use one of Crosstab utilities available. Or

SELECT Customer, ;
  SUM(IIF(MONTH(SaleDate)=1, Ammount, 0000000.00) AS Jan, ;
  SUM(IIF(MONTH(SaleDate)=2, Ammount, 0000000.00) AS Feb, ;
  SUM(IIF(MONTH(SaleDate)=3, Ammount, 0000000.00) AS Mar, ;
...
  SUM(IIF(MONTH(SaleDate)=12, Ammount, 0000000.00) AS Dec, ;
...