Query Count Total in a Text Box

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

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
 
Thank you Duane,

It worked great!

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

--
Duane Hookom
MS Access MVP
--

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
Click to expand...


.
Click to expand...
 
Back
Top