Store IIf results in a Graph/Chart

[access_viper]

Here is what I have:

A report based upon a table with the following values:

1 Table Employees

Columns:
Name, Score, Recommendation1, Recommendation2, Recommendation3

I also have unbound text fields in the report which contain the following in the control source:

=Sum(IIf([Score]="Below",1,0))

=Sum(IIf([Score]="Average",1,0))

=Sum(IIf([Score]="Above",1,0))

The three unbound fields correctly display the sum of the respective choices. My problem is that I need to translate this data into a chart. However, the chart only accepts information from a query or table. I have tried to update a field in my table with the results of the unbound field (using VBA) with no results.

Should I be using VBA or create a query that the chart can interpret?

Thanks in advance for reading.

 

[access_viper]

Thanks for the response.

The part about storing the running totals in a separate table is what I am having trouble with. With the IIF statement, I get the correct totals. How would I store the values in the other table and how should I construct the relationship (or is it necessary)?

Thanks.

 

[access_viper]

Gizmo,

Thanks for your response. I was able to solve my problem using a UNION SELECT Query.


Thanks, again.