Create a chart WITHOUT using tables or queries

  • Thread starter Thread starter noe1818 via AccessMonster.com
  • Start date Start date
N

noe1818 via AccessMonster.com

I want to be able to create a chart from some total boxes on my report. The
totals are not stored in any table, but I want to create a chart from them.
The problem is that chart wizard only uses tables or queries to make it's
graphs. Any way to do this?
 
Hi

A chart is a report.
Therefore the information shown is based on a Table or Query.

Try calculate your totals inside your report query
Then use the totals from the query to create your chart.

Have Fun

DeltaTech
 
Maybe you can help me. I have a series of option groups. The choices are
given values, but some have the same value (0). So I did a "IIF" statement,
saying that if the choice = some value, assign it a 0, otherwise give it the
chosen value. I had these statements in unbound text boxes so I could do a
total from these text boxes. Totals came from groups of the choices. I wanted
to create a graph from the total boxes. How could I have put these in a table
or query using the IFF statement and then created a graph from them?
 
Back
Top