Chart in a form

[Guest]

I created some fields in my form using the expression builder. I made a
calculation to find % of increase. Since the new field is not based on a
table, I cannot find a way to create a simple bar chart to display the %
increases. When I try to create the chart, it wants to base the info on a
table? Is there a way to create a graph in a form and use non-table info?

 

[Larry Linson]

I created some fields in my form using the expression builder. I made a
calculation to find % of increase. Since the new field is not based on a
table, I cannot find a way to create a simple bar chart to display the %
increases. When I try to create the chart, it wants to base the info on a
table? Is there a way to create a graph in a form and use non-table info?

AFAIK, it is just as common to base a graph on a Query as to base it on a
Table.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks Larry, I will try to setup in a query...but.... Is there a way to
setup a chart and base it on the form fields? After setting up a table that
had 05's Scores, and then 06's scores, I used the table to create a form that
showed both values. Next I created a field on the actual form and used an
expression to figure the rate of increase. I now wanted to just highlight
all those created fields (that aren't setup in a table or query) and chart
the %'s... Does that make sense?
Thanks again,
Trey