var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Text Box Calculating a Text Box Calculation?
I have several lines in report detail that are added then compared to a minimum commission rate. So if a+b+c>MinComm then the group total is a+b+c else it's MinComm.
I've got this figured out (more or less) but now I need the sum of these groups and want to calculate/sum the previous results (a+b+c or MinComm) which are a combination of the the results.
I've tried Sum([Reports]![ReportName]![TextBoxName]) to no avail. Is there a way to do this?
I've tried this in the query but am at a loss as to how to create the a+b+c calculation to compare to MinComm.
Thanks in advance for any help!
You can't sum a calculated control. Presuming you used an IIf() function for it, you can sum that:
Unfortunately, I don't think I can because the IIF statement has aggregates like so: =IIf([MinComm]>Sum([EarnedComm]),[MinComm],Sum([EarnedComm])).
This has got me stumped. sigh
If you want to sum it, it MUST be done at the query level, not the form or report level... you can try to fiddle it to make it work without doing so by using hidden controls and the RunningSum property, but I find that clunky and difficult to maintain, so I don't recommend it.
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "