Hello All! I really hope someone can point me in the right direction here!!!
Basically I have a report that has various summed footers and then a report footer that gives grand total. When I exported this into Excel it appears as a subtotalled spreadsheet with the footer cells as sum calculations and everything is/was great. However I have now replaced one of the basic report footers that used to say =Sum([Gross Revenue])with an IIF statement as follows :
=IIf([Text54]="GIL 2",IIf([Total Call Time Grand Total Sum]<=75000,([Total Call Time Grand Total Sum]*0.66),IIf([Total Call Time Grand Total Sum]>75000 And [Total Call Time Grand Total Sum]<=150000,(([Total Call Time Grand Total Sum]-75000)*0.65)+(75000*0.66),(([Total Call Time Grand Total Sum]-150000)*0.64)+(75000*0.65)+(75000*0.66))),Sum([Gross Revenue]))
When I run the report it all works as I expected it to and the calculated cell appears on the report/prints out from Access. All great so far....BUT when I export into Excel this new IIF calculated TextBox disappears!!! Does anyone know what I have got wrong? Any manna from above is as always greatly appreciated
Many thanks...
Tommy B
Basically I have a report that has various summed footers and then a report footer that gives grand total. When I exported this into Excel it appears as a subtotalled spreadsheet with the footer cells as sum calculations and everything is/was great. However I have now replaced one of the basic report footers that used to say =Sum([Gross Revenue])with an IIF statement as follows :
=IIf([Text54]="GIL 2",IIf([Total Call Time Grand Total Sum]<=75000,([Total Call Time Grand Total Sum]*0.66),IIf([Total Call Time Grand Total Sum]>75000 And [Total Call Time Grand Total Sum]<=150000,(([Total Call Time Grand Total Sum]-75000)*0.65)+(75000*0.66),(([Total Call Time Grand Total Sum]-150000)*0.64)+(75000*0.65)+(75000*0.66))),Sum([Gross Revenue]))
When I run the report it all works as I expected it to and the calculated cell appears on the report/prints out from Access. All great so far....BUT when I export into Excel this new IIF calculated TextBox disappears!!! Does anyone know what I have got wrong? Any manna from above is as always greatly appreciated
Many thanks...
Tommy B
