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?