Issue adding calculated fields into a subquery.
Posted on 2012-09-17
I am running into an issue where on each of my subreports on my main report, I need to create two calculated fields: [% of Total AR], and [% of Total (Unbilled)]. I tried to add these two fields into the main table (not a problem). Then I went into the main (non-append query: "qry_Project Manager_HISTORY" and add these two calculated fields, but was unable to do so.
The error I received after adding the two calculated fields then trying to run the main rpt was:
"Subqueries cannot be used in the expression (tbl_ProjManager_History.[AROver75]/[TotalAR]).
The fields I was trying to add, were the:
I am not able to do this and can't understand why. What I am doing wrong?