Calculation within the report

[aattas]

Gents,

I have a report that shows (attached) the different of results. I want to know how access report can calculate the results as follows:

Total of (1) =
Total of (2) =
Total of (3) =
Total of (null) =

 

[Ranman256]

Put the calculations in the query.
Summations in the report footers.

 

[CJ_London]

just a guess but in the report footer create 4 controls with the following as the controlsource

=sum(iif(numbercol=1,1,0))

change the value in red to 2,3 or null as required. Change 'numbercol' to the name of the relevant field/control

 

[aattas]

Gents,

My apology for the delay, i was on leave.

I tried the footer and it worked for the total, so i did with the grouping sum, and i got what i need.

Thankyou very much for helping.