Calculated fields on form as chart recordsource

A

Averil Pretty

Hello,

I have just finished creating a form that has fields
calculated based on other data in the form (the other data
is pulled directly from a table).

What I need to do now is have a chart on another form use
these calculated values and display. Is there a way I can
make the chart look at these fields and not a table or
query? Failing that how can I transfer the values into a
table each time the record is viewed or updated?

Thanks in advance, and I apologise if this has been
answered before... I searched but didn't come up with
anything so may have been searching for the wrong thing.

Regards,
Averil Pretty
 
Top