Calculation within the report (1 Viewer)

A

aattas

Registered User.

Local time

Today, 09:13

Joined

Dec 24, 2014

Messages

74

• Mar 17, 2019

• #1

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) =

 

Attachments

• 
  List of codes.JPG

  31 KB · Views: 72

Ranman256

Well-known member

Local time

Today, 02:13

Joined

Apr 9, 2015

Messages

4,339

• Mar 17, 2019

• #2

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

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 07:13

Joined

Feb 19, 2013

Messages

16,607

• Mar 17, 2019

• #3

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

 

A

aattas

Registered User.

Local time

Today, 09:13

Joined

Dec 24, 2014

Messages

74

• Mar 24, 2019

• #4

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.