Line Chart Trouble

I have a query which calculates a percentage based on 2 values. So I have 4
columns in my query:

Week Ending Date, Drops, Calls, Calls2Drop

The query is grouped by week ending date, includes the sum of drops and the
sum of calls, and a percentage that is Calls2Drop(which is
SumOfCalls/SumOfDrops). Simple.

Now I am trying to create a line chart with Week Ending Date being the
x-axis and the Calls2Drop percent as the value. All it will let me use is
Count(Calls2Drop). I just want the exact value from the query represented on
the chart, not a count of the values. When I try to change the SQL to only
include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part of
an aggregate function in the query. Why should it have to be? How do I get
around this? Any help is appreciated.

Please provide the SQL view of your chart's Row Source.

--
Duane Hookom
MS Access MVP


"This Guy" wrote in message
...
I have a query which calculates a percentage based on 2 values. So I have
4
columns in my query:

Week Ending Date, Drops, Calls, Calls2Drop

The query is grouped by week ending date, includes the sum of drops and
the
sum of calls, and a percentage that is Calls2Drop(which is
SumOfCalls/SumOfDrops). Simple.

Now I am trying to create a line chart with Week Ending Date being the
x-axis and the Calls2Drop percent as the value. All it will let me use is
Count(Calls2Drop). I just want the exact value from the query represented
on
the chart, not a count of the values. When I try to change the SQL to
only
include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part
of
an aggregate function in the query. Why should it have to be? How do I
get
around this? Any help is appreciated.