Report with complex data points

[Guest]

I have a report that shows stats for my basketball team. I would like to be
able to put a section at the bottom that shows averages per year. The report
is sorted by player and year. I can subtotal by year in the detail of the
report by not in the player footer. Is there a way around this. My intial
thought was to use the dsum function but I only know how to use that function
with a specific player

=DSum("[TURN OVERS]","[13u statistics]","[Player] = 'majic johson'"). This
will not work in the footer of a report because it will return the player
selected not the one related to the detail.

 

[Duane Hookom]

I would probably create a subreport and add it to your main report. However,
if you want to use DSum(), try:
=DSum("[TURN OVERS]","[13u statistics]","[Player] = """ & [PlayerField] &
"""")

 

[Guest]

thank you

I would probably create a subreport and add it to your main report. However,
if you want to use DSum(), try:
=DSum("[TURN OVERS]","[13u statistics]","[Player] = """ & [PlayerField] &
"""")

--
Duane Hookom
MS Access MVP
--

I have a report that shows stats for my basketball team. I would like to
be
able to put a section at the bottom that shows averages per year. The
report
is sorted by player and year. I can subtotal by year in the detail of the
report by not in the player footer. Is there a way around this. My
intial
thought was to use the dsum function but I only know how to use that
function
with a specific player

=DSum("[TURN OVERS]","[13u statistics]","[Player] = 'majic johson'").
This
will not work in the footer of a report because it will return the player
selected not the one related to the detail.