Saving Calculated info into a table?

[Benjamin Bolduc]

Hi everyone,

I'm trying to make a simple chart from 2 calculated controls on a report. Since the charts in access can only be made from a table, I was wondering if there was any way to save the results of the totals feilds into a table. I'm not even sure if it's possible but it would be really handy if it was.

If anyone has any ideas, please share them with me. I've left posts with this problem a few times before, and have had no replys.

Thanks in advance!

 

[Jack Cowley]

If you entering data into the two fields that you use for calculations you can put code similar to this in the After Update event of the second field in which you enter data:

Me![Total] = Me![CalcField1] * Me![CalcField2]

Or whatever the calculation is. I assume that there is a bound field on the form named Total...

 

[David R]

Where did you get that Access can only build charts off of tables? I just built one from a query 10 seconds ago.

 

[Benjamin Bolduc]

Ok then. But how do you put calculated feilds from a report onto a query?

 

[David R]

Calculate the fields in the query behind the report. Then they'll be there for the chart, and you can just refer to the calculated field to display it on your report.

 

[Benjamin Bolduc]

Thank you, Thats extremely helpful

 

[Benjamin Bolduc]

Shoot! I just tried what you said but I dont think it'll work.
My report is too complicated having muliple subreports. I don't know how to make a single query that can hold all of the data and coding that is involved with the report itself.
Is there a way to export this information to Excel and have it be updateable. So that every time I open the Excel chart it will update the information based on the Access report?

Again, I dont know if this is possible but any help would be very much appreciated.

Thank you!


[This message has been edited by Benjamin Bolduc (edited 04-29-2002).]