Report showing totals of monthly wages

[gscma1]

I have a database which holds employees wages weekly. i need a report to show the monthly total of each employees wages.

e.g.

Emp Id Forename Surname Gross Wage
1 Joe Bloggs £2000.00
2 Fred Smith £1670.00
3 Barry White £1750.00 etc...

however i can only seem to produce a report which looks like this:

Emp Id Forename Surname Gross Wage
1 Joe Bloggs £500.00
1 Joe Bloggs £500.00
1 Joe Bloggs £400.00
1 Joe Bloggs £600.00
2 Fred Smith £400.00
2 Fred Smith £400.00
2 Fred Smith £400.00
2 Fred Smith £470.00 etc...

Can anyone help me?

Thanks

 

[rjoubert]

Group your report (View - Sorting and Grouping) by the Emp Id field, add a group header and group footer. In the group header put the fields to display the name of the employee, and in the group footer put an unbound textbox with a control source of =Sum([GrossWageFieldName]) (You'll need to replace GrossWageFieldName with the name of your Gross Wage field).