displaying total record count when using a bar chart?

H

Howard

I understand that when you have a report with a chart in it thge chart, not
the report has the record source defined.
I have a simple bar chart that displays how many times students from each
year group in a school have been withdrawn.
what I would like to do is show the total number of withdrawals in the
report header.
Howard
 
G

Guest

You should be able to create a query that returns the correct value. You can
then display the value with DLookup() or a subreport or add the query to your
report's recordsource.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie Chart will only Display one slice - 100% 1
How to count records using count(*) in a chart report 3
Add text box with Total to chart 1
Bound Chart in Report Issues - Access 2007 4
Parameter Report with a Chart in the footer 1
Bar Chart based on report calculations... 4
Display query parameters in a chart 5
Formatting a Chart Object 4

Top