S
screenwriter_12
Hi, folks -
I've drafted an MS Access report that charts the "% complete" of four
different tasks. It starts with 4 textboxes (employees, revenue,
growth & industry) that calculate how many records in my [Orgs] table
meet each query's criteria. Today the controls are sitting at:
=DCount("[OrgName]","qry employees") = 2.09%
=DCount("[OrgName]","qry revenue") = 2.24%
=DCount("[OrgName]","qry growth") = 2.19%
=DCount("[OrgName]","qry industry") = 11.24%
What I would like to do is create a 5th control that AVERAGES these
numbers:
[AvgComplete] = 4.44%
And then link a simple pie chart that shows [AvgComplete] against the
remaining 95.56% incomplete. But my problem is:
1) I'm unsure how to average those 4 controls to get [AvgComplete],
and
2) Charts appear to only work from a query, but the only field I need
to plug into my chart is an unbound calculation [AvgComplete].
Hope all this makes sense - Does anyone have any advice or
suggestions?
I appreciate your help!
I've drafted an MS Access report that charts the "% complete" of four
different tasks. It starts with 4 textboxes (employees, revenue,
growth & industry) that calculate how many records in my [Orgs] table
meet each query's criteria. Today the controls are sitting at:
=DCount("[OrgName]","qry employees") = 2.09%
=DCount("[OrgName]","qry revenue") = 2.24%
=DCount("[OrgName]","qry growth") = 2.19%
=DCount("[OrgName]","qry industry") = 11.24%
What I would like to do is create a 5th control that AVERAGES these
numbers:
[AvgComplete] = 4.44%
And then link a simple pie chart that shows [AvgComplete] against the
remaining 95.56% incomplete. But my problem is:
1) I'm unsure how to average those 4 controls to get [AvgComplete],
and
2) Charts appear to only work from a query, but the only field I need
to plug into my chart is an unbound calculation [AvgComplete].
Hope all this makes sense - Does anyone have any advice or
suggestions?
I appreciate your help!