Report with complex data points

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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] &
"""")
 
thank you

Duane Hookom said:
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
--

shayler said:
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.
Click to expand...
Click to expand...
 
Back
Top