Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-17-2019, 03:58 AM   #1
aattas
Newly Registered User
 
Join Date: Dec 2014
Posts: 47
Thanks: 11
Thanked 0 Times in 0 Posts
aattas is on a distinguished road
Calculation within the report

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) =
Attached Images
File Type: jpg List of codes.JPG (31.0 KB, 14 views)

aattas is offline   Reply With Quote
Old 03-17-2019, 05:16 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,288
Thanks: 0
Thanked 721 Times in 706 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Calculation within the report

Put the calculations in the query.
Summations in the report footers.
Ranman256 is offline   Reply With Quote
The Following User Says Thank You to Ranman256 For This Useful Post:
aattas (03-24-2019)
Old 03-17-2019, 05:19 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,685
Thanks: 40
Thanked 3,465 Times in 3,354 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Calculation within the report

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

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
aattas (03-24-2019)
Old 03-24-2019, 12:33 AM   #4
aattas
Newly Registered User
 
Join Date: Dec 2014
Posts: 47
Thanks: 11
Thanked 0 Times in 0 Posts
aattas is on a distinguished road
Re: Calculation within the report

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.

aattas is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report calculation.. akumar118 Reports 4 03-19-2010 02:51 AM
Report Calculation Only1Abhi General 2 01-25-2004 04:19 PM
[SOLVED] Calculation in report tannagirl Reports 1 11-20-2002 01:15 PM
Calculation Report camaroltd82 Reports 1 07-26-2002 12:05 PM
Calculation in Report gcormier Reports 1 10-12-2000 10:02 AM




All times are GMT -8. The time now is 01:18 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World