Sum of a Report

[Cubsm22p]

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.

 

[theDBguy]

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

 

[Cubsm22p]

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)

 

[theDBguy]

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.

 

[Cubsm22p]

But i want to just count the records with [Job Type] 'JL' not all the the records

 

[theDBguy]

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

 

[Cubsm22p]

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

 

[theDBguy]

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.

 

[Cubsm22p]

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

something like that

 

[theDBguy]

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

 

[Cubsm22p]

Works Great thanks

 

[theDBguy]

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