Create a chart WITHOUT using tables or queries

[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?

 

[Douglas J. Steele]

As far as I'm aware, there's no way using the built-in Graph objects.

 

[DeltaTech]

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

 

[noe1818 via AccessMonster.com]

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?