I'm trying to write an IIF statement for the Value of my Crosstab query.
If you open the attached database, chose a Report and a Date and click the button, you'll see the query (qrySummary) shows 2 columns of percentages. Then there are '1's in the grid of the crosstab query.
What i would like is:
for the 4 columns titled: Dev Overrun, Dev Underrun, Maint Overrun, Maint Underrun, replace the '1's with the percentages in the grid.
It seems like I can do one or the other, but not both.
--I can either have '1's in the grid for everything (as shown in the qrySummary) or
--I can have percentages for the Dev Overrun, Dev Underrun, Maint Overrun, Maint Underrun columns, but not have '1's for the other columns (as shown in qrySummary2).
Can I have both the '1's and the percentages?
I have spent about 4 hours on this so far, and no luck!
Help!