Running Sum for Specific Values

[Brandon]

Ok, I've got a table which has an the monthly totals for certain species of
birds.

On each value, there is Bird Species, Total Blood Samples, Total Recaptures,
Total SLE Positive, Total WEE Positive, Total WNV Positive, and Total Repeat
WNV Positive.

Now for how this applies to my report.

The report I need to make, I"ve just been making it in excel prior to now.

It has a species column, A Blood Samples Column, A recpatures Column, and a
SLE/WEE/WNV Positives Column.

Under each column are several subcolumns. For example: Under the Blood
samples Column heading, there are three sub-columns: Prev. [Current Month]
and Total.

Prev. (previous) Pulls the total value from the previous month. If the month
is january, it starts over.

[Current Month] Would say the number of blood captures for this month.

And Total would be Prev + Current Month.


Now I need it to make a running sum of the [Current Month] values but keep
it species definitive. Like, only the house finches will be added to the
house finch running sum. Right now I can get it to do everything I want but
make it so the running sum only goes to other entries with the same bird
species.

Any help would be greatly appreciated. Thanks in advance.

 

[Duane Hookom]

You can possibly use an expression like:
=Abs([Species]="house finches") * [WNV Positive]
Then set a running sum on this text box which would only total "house
finches".

 

[Brandon]

Anybody else?

 

[Duane Hookom]

Anybody else what?
Normally if you try something that doesn't work, you should at least reply
back with the results.