Access Report Sum Totals based on another column

[IntoTheVoid]

Hi,

I am stuck on an MS Access 2010 report. I have the report grouped by a budget code. There is a column for total number of jobs and a column for the job type. I want to sub total the total number of jobs based on job type. So for example if the job type is skilled then create a sub total for the total number of jobs for skilled. The sub total needs to go in the footer of the budget code grouping, as I will need a subtotal for each budget code grouping. I tried an Iif expression but this does not work.

I would be grateful for anyone able to solve this.

 

[IntoTheVoid]

In the end I created two calculated fields in the underlying table using Iif statements. I then created two textboxes in the report group footer for budget code and used these to sum and display the totals.