Totalling A Date Field

[sprog]

I am trying to calculate all wages paid for a year.

I can select the 26 fortnightly pay dates, but everytime I run the report, it enters figures for every single employee paid on each individual pay date. I would like it all grouped together to show one total figure.

How can I do this? Any help appreciated.

 

[rosemaryl]

Dear Sprog,

Group by Year and then insert a summary for the wage field for that year group.

Right click your wage field in the detail section, click Insert Summary/Sum and choose by the Year Group Field.

Suppress the details and you will have the Year in the Group Header and the Wages for Year in the Footer. If you want them on the same line, drag the summary field to the group header and suppress the group footer.

Hope that helps,

ro


Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.