Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-28-2019, 10:44 AM   #1
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Sum of a Report

I would like to count just the total of 'JL' in each row. right now i can only to get it to sum the total. Any help would be appreciated.
rpthelp1.PNGprthelp2.PNG

Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 10:59 AM   #2
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Hi. Just a guess but if you're using something like =Sum([FieldName]), then try something like this: =Sum(IIf([Job Type]="JL",[FieldName],0))
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 03-28-2019, 11:13 AM   #3
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Re: Sum of a Report

What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report


=Count(IF([Job Type]="JL"),COUNT,DoNothing)
Or
=IF([Job Type]="JL"),COUNT,DoNothing)

Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 11:15 AM   #4
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Quote:
Originally Posted by Cubsm22p View Post
What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report
Hi. I'm not sure either because the image you posted seems to be cut off at the right side to see what you're trying to total. What is the Control Source you're using now to do the total? I gave you what I thought it was. Maybe you can show us what you're actually using.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 03-28-2019, 11:24 AM   #5
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Re: Sum of a Report

rpthelp4.PNG
rpthelp5.PNG

But i want to just count the records with [Job Type] 'JL' not all the the records
Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 11:27 AM   #6
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Hi. Okay. Thanks for the additional information. I read counting as different from totalling. Try this: =Sum(IIf([Job Type]="JL",1,0))
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Cubsm22p (03-28-2019)
Old 03-28-2019, 11:35 AM   #7
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Re: Sum of a Report

Thanks that works , how would i count the total if i want 'JL' and 'JLS' totaled.

Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 11:38 AM   #8
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Hi. Again, I tend to get confused when you use count and total at the same time. They mean different things to me. Can you post an example of what you mean? Thanks.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 03-28-2019, 11:41 AM   #9
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Re: Sum of a Report

=Sum(IIf([Job Type]="JL" or "JLS",1,0))

something like that
Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 11:43 AM   #10
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Okay. For something like that, you could try: =Sum(IIf([Job Type]="JL" OR [Job Type]="JLS",1,0))
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Cubsm22p (03-28-2019)
Old 03-28-2019, 12:01 PM   #11
Cubsm22p
Newly Registered User
 
Join Date: Feb 2018
Posts: 36
Thanks: 5
Thanked 0 Times in 0 Posts
Cubsm22p is on a distinguished road
Re: Sum of a Report

Works Great thanks
Cubsm22p is offline   Reply With Quote
Old 03-28-2019, 12:02 PM   #12
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,227 Times in 1,208 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sum of a Report

Hi. You're welcome. We're happy to assist. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   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
[SOLVED] Change report filters and report label caption based on form command newdistrict Reports 6 07-23-2017 12:52 PM
Open report button to select data from 7 list boxes and present in a report Gavin59 Forms 19 03-07-2016 07:16 PM
[SOLVED] Open sub report from main report by selecting report name scopes456 Reports 3 12-15-2015 11:01 AM
Does MS Access Report support Hide/Show fields at the Report View time? accesser2003 General 3 06-13-2014 06:15 AM
Invoice report problem, report show items from previous invoices. saltyseadog Reports 1 04-16-2013 07:30 AM




All times are GMT -8. The time now is 05:32 AM.


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