D
Dragonfly
I am relatively new to building reports & using Access 2003. I am finding it
challenging to use some of the help menus online because I don't always know
the terminology to use in order to ask the right questions. Here goes:
I have a report that lists volunteers [SortName] and how many hours they have
given for each department [RH], [IH], [JH]. The volunteers with the date &
hours are grouped by the volunteer name [SortName]. In the group footer, I
display the volunteer name and the sums of hours for each dept.(ie. =Sum[RH];
Sum[IH], Sum[JH]).
In the report footer, I am able to display the sums for all individuals for
each department. That works great.
I also want to display a count of the number of individuals that gave hours
in each department in the report footer. I have tried variations of DCOUNT
trying to set a criteria (using IIF) to only count the individual if their
sum of their hours for a given department are greater than zero. One of my
challenges is that each individual may have given hours on more than one date
but I only want to count that individual once. (Which is why I've trid basing
the IIF expression on the sum being > 0) At this point, I've tried so many
different ways with no success that I'm getting a bit cross-eyed and just
hoping that this explanation makes sense to someone.
Thanks.
challenging to use some of the help menus online because I don't always know
the terminology to use in order to ask the right questions. Here goes:
I have a report that lists volunteers [SortName] and how many hours they have
given for each department [RH], [IH], [JH]. The volunteers with the date &
hours are grouped by the volunteer name [SortName]. In the group footer, I
display the volunteer name and the sums of hours for each dept.(ie. =Sum[RH];
Sum[IH], Sum[JH]).
In the report footer, I am able to display the sums for all individuals for
each department. That works great.
I also want to display a count of the number of individuals that gave hours
in each department in the report footer. I have tried variations of DCOUNT
trying to set a criteria (using IIF) to only count the individual if their
sum of their hours for a given department are greater than zero. One of my
challenges is that each individual may have given hours on more than one date
but I only want to count that individual once. (Which is why I've trid basing
the IIF expression on the sum being > 0) At this point, I've tried so many
different ways with no success that I'm getting a bit cross-eyed and just
hoping that this explanation makes sense to someone.
Thanks.