Home Forum Contact

 Access World Forums Calculation within the report
 Register FAQ Members List Social Groups Top Posters Search Today's Posts

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
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
 List of codes.JPG (31.0 KB, 14 views)

 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 Re: Calculation within the report Put the calculations in the query. Summations in the report footers.
 The Following User Says Thank You to Ranman256 For This Useful Post: aattas (03-24-2019)
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
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

 The Following User Says Thank You to CJ_London For This Useful Post: aattas (03-24-2019)
 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 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.

 Thread Tools Display Modes Rate This Thread Linear Mode Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business

 Similar Threads Thread Thread Starter Forum Replies Last Post akumar118 Reports 4 03-19-2010 02:51 AM Only1Abhi General 2 01-25-2004 04:19 PM [SOLVED] Calculation in report tannagirl Reports 1 11-20-2002 01:15 PM camaroltd82 Reports 1 07-26-2002 12:05 PM 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