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.

You should not do this by making new tables. Use queries as the recordsource for reports to get what you need as far as totals go.