Try:
=DSum("[Count Of]"," [Chart Query]")

--
Duane Hookom
MS Access MVP
--

"Jennifer" wrote in message
...
I have created a chart in a report based on a query. The
query is a simple Count and Group By query with two
columns (Count Of and Objects) and about 7 or 8 records.
The chart works just fine with the query.

I would like to make a Text Box or something that will sum
up the total number of objects. In a Text Box, under
Control Source, I entered:
=SUM([Chart Query].[Count Of])

This gives me #Error.

Is there a way to total the numbers in the Count Of column?

Please help,

Jennifer