Without knowing anything about how your database is designed, it's a crap-shoot to come up with code to fill your requirements, but, ASSUMING that you have a table containing previous payroll data per wmployee per pay period, you would do something along the lines of
SELECT SUM(Basic_Salary), Sum(Allowances), Sum(Deductions), Sum(Net_Pay) and Sum(Tax) From Payroll Where PayRollDate >= '01-JAN-07'
(ps - don't use spaces in object names...)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert