IIf Statement on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following that used to work when I used a header in report. NOw I
want to show all 3 choices whether the sums are 0 or not. I currently have
countof for each in my query.

=Sum(IIf([Type of Service]="Physical Call",1,0))

I need help to modify so that in a text box I could sum individually. [Type
of Service] can be 'Service, 'Agency' and 'Other'

Can one just add a piece after [Type of Service] so that is counts [Type of
Service] for 'Service' , etc.

Table on report will look like when working!
Physical Calls Phone Calls
Service Calls # #
Agency Calls # #
Other # #


Need help with this please.
 
Here is some info to help you help me. Below is one of the IIF's I wanted to
modify actually so that the sum will tell me # "Physical Call" for 'Service'
The number I get now just returns the number by call type I set = to.

Now I need to sum the number of Physical Call Service and number of Phone
Call Service

=Sum(IIf([Call Type]="Service",1,0))
 
Solved my issue so forget this post

Here is the IIf that worked.

=Sum(IIf([Call Type]="Service" And [Type of Service]="Physical Call",1,0)

bdehning said:
Here is some info to help you help me. Below is one of the IIF's I wanted to
modify actually so that the sum will tell me # "Physical Call" for 'Service'
The number I get now just returns the number by call type I set = to.

Now I need to sum the number of Physical Call Service and number of Phone
Call Service

=Sum(IIf([Call Type]="Service",1,0))

bdehning said:
I have the following that used to work when I used a header in report. NOw I
want to show all 3 choices whether the sums are 0 or not. I currently have
countof for each in my query.

=Sum(IIf([Type of Service]="Physical Call",1,0))

I need help to modify so that in a text box I could sum individually. [Type
of Service] can be 'Service, 'Agency' and 'Other'

Can one just add a piece after [Type of Service] so that is counts [Type of
Service] for 'Service' , etc.

Table on report will look like when working!
Physical Calls Phone Calls
Service Calls # #
Agency Calls # #
Other # #


Need help with this please.
Click to expand...
Click to expand...
 
Back
Top