If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Count Total in a Text Box
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thank you Duane,
It worked great! -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating a form based on a query using the "total" feature | James | Using Forms | 1 | August 27th, 2004 01:29 PM |
Stup-id question about Count query | Lunga | Running & Setting Up Queries | 8 | August 26th, 2004 04:35 PM |
Count in Query | Kris | Running & Setting Up Queries | 1 | August 24th, 2004 11:00 PM |
Retrieving Count of rows returned from MS Access Query | Don | General Discussion | 2 | June 27th, 2004 07:54 PM |
is there a formula that can count a range of cells with text? | Frank Kabel | Worksheet Functions | 0 | March 11th, 2004 09:04 PM |