| | |
|
|
|
Sum and Count |
|---|
| message from =?Utf-8?B?YmRlaG5pbmc=?= on 19 May 2004 |
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 Jun
|
| =?Utf-8?B?YmRlaG5pbmc=?= replied to =?Utf-8?B?YmRlaG5pbmc=?= on 19 May 2004 |
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 only with my field for Scheduled Service Month being mm/dd/yyyy?
Does this make sense?
|
| tina replied to =?Utf-8?B?YmRlaG5pbmc=?= on 20 May 2004 |
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" <anonymous@discussions.microsoft.com> wrote in message
news:AAF795E7-315E-4440-BA01-152A8A9A659F@microsoft.com...
only with my field for Scheduled Service Month being mm/dd/yyyy?
|
|
Archived message: Sum and Count (Microsoft Access)
