I understand Access will not Sum calculated columns in a Report unless the original calculation is repeated in the Sum statement.
One of my calculated columns includes an IIF statement...
What structure would someone suggest to Sum a complex IIF statement?
Everything I have tried comes out 'too complex'!
All suggestions are greatly appreciated!!
One of my calculated columns includes an IIF statement...
What structure would someone suggest to Sum a complex IIF statement?
Everything I have tried comes out 'too complex'!
All suggestions are greatly appreciated!!