Trying to sum values in a report footer

SteveL13
SteveL13 used Ask the Experts™
on
I'm trying to sum values in the report footer.  The value I'm trying to sum is txtQty1 where a field named QLBreakoutSortOrder is null.  I don't know how to write the control source.  Can someone help?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Not sure what the full scope of this question is, ...

But you can certainly convert Nulls to zeros by using the NZ() function...
NZ(QLBreakoutSortOrder,0 )
...or use an IIF:
IIF(isnull(QLBreakoutSortOrder),0,QLBreakoutSortOrder )

To be sure, you will have to post a bit more about this issue.
...or simply post a small sample db that illustrates this issue, ...and clearly explain what you need the result to be...
John TsioumprisSoftware & Systems Engineer

Commented:
=Sum(Nz(Your field,0))
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
I think what you are looking for, is in the ControlSource of the textbox in the report footer, use:

=Sum(IIF(isnull([QLBreakoutSortOrder]),0, txtQty1) )

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial