Charts based on calculated feilds

[Benjamin Bolduc]

Hi everyone!

I'm working on a report and I'd like to put a chart on it. The report is very complicated with tons of calculated feilds but all I need to use is just 2 of those feilds to make this chart. It seems like it would be really easy, just a basic line graph showing inventory going up and down over time.
Unfortunatly, I've learned that nothing is as easy as it seems with Access.
Does anyone have any ideas how I can incorperate this chart onto my report?
The graph wizard doesnt even give you the option of using calculated feilds.
Is there any way of using an Excel chart with Access data?
Any advice would be very much appreciated.

P.S. To the many that have helped me this far-- Thanks!

 

[Dominato]

May not be the best way, but you could try making a query with calculated fields then base the chart off of that.

 

[Benjamin Bolduc]

I tried putting calculated feilds into a Query but it didn't work. Maybe I'm not doing somthing right. Any other ideas?