E eugz Registered User. Local time Today, 16:16 Joined Aug 31, 2004 Messages 128 Sep 27, 2007 #1 Hi All. In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent. Thanks. Last edited: Sep 27, 2007
Hi All. In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent. Thanks.
Guus2005 AWF VIP Local time Today, 22:16 Joined Jun 26, 2007 Messages 2,642 Sep 28, 2007 #2 Code: select avg(rate), emplyeename from table group by employeename having date between startdate and enddate
Code: select avg(rate), emplyeename from table group by employeename having date between startdate and enddate
