Hi,
  I have a problem with one of my view. Basically, I need to create a
view
to sum the amount in Table A grouped by the EMPLOYEE_ID. But I also
need the ability to limit the date range.

  What I need to do is creating a view with the ability to limit the
date
range want the result sets to be broken down by employee_id (not
dates).
Is there an easy way to accomplish this ?

Table_A
-----------
ID      EMPLOYEE_ID        DATE         AMOUNT
1                1                  01/01/2006      100.00
2                1                  01/02/2006        50.00
3                2                  01/02/2006        25.00
4                1                  01/03/2006        10.00
5                2                  01/03/2006        15.00
6                3                  01/03/2006          5.00
7                1                  01/04/2006        10.00
8                2                  01/04/2006        20.00
9                3                  01/04/2006        30.00

---------------------------------------------------------------------
SELECT EMPLOYEE_ID,DATE,SUM(AMOUNT)
FROM Table_A
GROUP BY EMPLOYEE_ID,DATE ;
--------------------------------------------------------------------
This query will give me the DATE column, so that I can
pass in the date range I want in the view, but the result
sets will also be broken down by employee and date.

--------------------------------------------------------
SELECT EMPLOYEE,SUM(AMOUNT)
FROM Table_A
GROUP BY EMPLOYEE_ID;
--------------------------------------------------------
 This query will provide me what I need, but when
I create the view over it, there is no way to pass in
the date range I want.

  Any experts out there ? :-) I must accomplish this
in a view. I would appreciate any advices anyone can
give.

Thanks