Chart from Report Results

[tikkat3]

Can a chart be created from a field within a report? The fields in question contain calculations based on data from a query.

When trying to create a chart, Access will only let me see tables and queries. How can this be done?

 

[boblarson]

Include the calculation in your report's query.

 

[tikkat3]

I see what you are saying. However, the calculations required are in the report's footer - they are totals/percentage calculations based upon other calculations in the footer.

e.g.

TxtBox1: Totals of column A
TxtBox2: Totals of column B
TxtBox3: Totals of column C

TxtBox4: TxtBox1 + TxtBox2 + TxtBox3

TxtBox5: TxtBox3 / TxtBox1 as a percentage

As these are total sums can these calculations be done in the query? If so, I have not yet found a way of doing so. If I attempt it, I get meaningless results.

 

[boblarson]

You'll have to then create aggregate queries to get what you are getting with the text boxes and use those. Unfortunately, I don't know of another way.

 

[tikkat3]

I thought it might not be as simple as I had hoped. Thanks for the help anyhow!