Grouping Table Data

[JJT]

I have a table with over 500 records with the following fields. Category, Date, Grand Total, Total Male, Total Female. Many of the records have the same Category and Date.

Is it possible to create a new table which combines the records with have the same Category and Date and also total the Grand Total, Total Male and Total Female fields ?

Thanks....much.