Limit records in sum on report

[diaare]

I am a fairly new user to Access.

I have created a report that shows our AP vendor toals for the past four
years by the commodity which we buy from them. My report is set up as
follows...

BaseComm
SecondComm
(detail) Vendor name 06total 05total 04total 03total
Sum SecondComm
Sum BaseComm

and in the report footer the grand total

Now...in the report details there is a BaseComm called "non Raw Materials"
for utiliies, services, etc. I woul like to, in the report footer, be able
to subtract that total out of the grand total so that I can see the true cost
of only Raw Goods for the four years. Is there a way to limit the sum to
only the one BaseComm in the footer?

 

[Duane Hookom]

Without a good understanding of your data, you can generically limit results
of sums in group or report headers or footers with expressions like:
to get the sum of hours worked by the HR dept:
=Sum(Abs([Dept]="HR") * [HoursWorked])
to get the sum of hours worked by non-HR depts:
=Sum(Abs([Dept]<>"HR") * [HoursWorked])

 

[diaare]

That is exactly what I was needing. Thanks for your help!

Diane

Without a good understanding of your data, you can generically limit results
of sums in group or report headers or footers with expressions like:
to get the sum of hours worked by the HR dept:
=Sum(Abs([Dept]="HR") * [HoursWorked])
to get the sum of hours worked by non-HR depts:
=Sum(Abs([Dept]<>"HR") * [HoursWorked])

--
Duane Hookom
Microsoft Access MVP

I am a fairly new user to Access.

I have created a report that shows our AP vendor toals for the past four
years by the commodity which we buy from them. My report is set up as
follows...

BaseComm
SecondComm
(detail) Vendor name 06total 05total 04total 03total
Sum SecondComm
Sum BaseComm

and in the report footer the grand total

Now...in the report details there is a BaseComm called "non Raw Materials"
for utiliies, services, etc. I woul like to, in the report footer, be able
to subtract that total out of the grand total so that I can see the true cost
of only Raw Goods for the four years. Is there a way to limit the sum to
only the one BaseComm in the footer?