Sum and Count

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

Guest

I use =Sum([CountOfScheduled Service Month]) to show total number of calls for month in a report with a sorting by Month

How would I have to structure the above to be able to count number by months to be able to show numbers ina report in columns? Like I said I do have the count forr each call by a date already. I just need the right statement that I can change to count or sum for each month in a report.

Jan Feb March April May Ju
# # # # # #
 
I should have asked my question better. I should be using the following with change

=IIf([Scheduled Service Month]???,1,0)

What should the ??? be for the above statement if I want to calculate Jan only with my field for Scheduled Service Month being mm/dd/yyyy

Does this make sense?
 
if you want to count the January dates only, try

=IIf(Month([Scheduled Service Month]) = 1,1,0)

to count February, change to

=IIf(Month([Scheduled Service Month]) = 2,1,0)

etc, etc. i don't know where you're doing the counting, but if this is a
calculated control in a report, you can count in the same calculation, as

=Sum(IIf(Month([Scheduled Service Month]) = 1,1,0))

hth

bdehning said:
I should have asked my question better. I should be using the following with changes

=IIf([Scheduled Service Month]???,1,0)

What should the ??? be for the above statement if I want to calculate Jan
Click to expand...
only with my field for Scheduled Service Month being mm/dd/yyyy?
 
Back
Top