Group By

Wondered if anyone could put me on the right track. I have a table with 5 columns ID, Present, Authorised, UnAuthorised, Date I want to aggregate the table by the ID between Dates Then calculate...