Using calculated fields from query in a form/report

[wellstones]

Hello all,

I have information from calculated fields in a query that i would like to be able to filter and display in a form or a report.

The calculated fields are part of a pivot table/pivot chart that i use to sort the data that is collected. the problem is that these are not any run of the mill calculated fields, we're talking about an IIF statement that has four different conditions that is based on another calculated field in the query.



Ive tried to create forms and reports from the query but the calculated fields wont transfer over.

Am I stuck recreating the calculated fields in a the form or is there an easier way?

[wellstones]

here is an example of what in working with.

the sigma level and otd percentage are both calculated fields and i want to be able to, in a form or report, select a vendor and have the data displayed from these calculated fields. i would also like to be able to display on that same form a pivot chart of the same data